Excel compute time
We have an Excel spreadsheet that volunteers use to document their time working. The time in an out is based on 12-hour time (am/pm). I would like a formula that would use the in and out time to compute number of hours worked. Anyone know how to do this?
Software/Hardware used:
Software/Hardware used:
ASKED:
February 15, 2008 12:51 AM
UPDATED:
February 2, 2011 3:07 AM
Answer Wiki:
I believe that this formula will give you want you are looking for.
<pre>=HOUR(SUM(B1-A1)) & ":" & MINUTE(SUM(B1-A1))</pre>
This function assumes that A1 is the starting time, and that B1 is the Ending Time. You do need to make sure that Excel understands that the columns A and B are setup in the time format, and don't have just text in there. If you need to handle overnight shifts this will need to be adjusted, but if everything is single day work without going over midnight it'll work just fine.
To see all answers submitted to the Answer Wiki: View Answer History.
Thank you so much, Mrdenny! The formula works perfectly!
Thank you for the excel formula… it works perfectly…