# minutes between two cells (Time Card Spreadsheet)

[David Kuhn]

Hello there,

I am doing a spreadsheet to automatically figure out a time card.

I want to be able to have cells for start time each day and leave time
each day. I then want to have Excel figure out how much time was
worked that day (it will be more complex and perhaps job oriented).

For example:
Start Time: 6:00 AM
Stop Time: 2:30 PM

Time Worked: 8.5 hours

How do I substract the start time cell from the stop time cell to
calulate the minutes (and or hours and minutes) between those two
times?

Thank you kindly,

Dave

 

[Jonathan Rynd]

(e-mail address removed) (David Kuhn) wrote in @posting.google.com:

How do I substract the start time cell from the stop time cell to
calulate the minutes (and or hours and minutes) between those two
times?

Times can be subtracted just like any numeric value. For instance if start
time is in cell B1 and stop time is in cell B2 then to get the time elapsed
you would just put =b2-b1. If you format the cell as time it will give you
hours:minutes.