Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have time sheets that people fill out and and calculate by hand. I would
like to insert a formula that will calculate the hours and minutes worked. An example would be: Time In Time Out Time In Time Out # Hours 8am 11am 12pm 5:30pm 8.5 It would be even better if I could get "8 Hours and 30 Minutes" instead of just "8.5." I'm thinking the only way to do this would be to use army time because the am or pm will just get in the way of the calculation, but if it is possible to leave that would be great as well. Thanks in advance for any assistance! Let me know if there is any additional information needed. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
Problem with converting decimal time to hours and minutes | Excel Discussion (Misc queries) | |||
Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
Problem converting Hours to Days, Hours, Minutes | Excel Worksheet Functions |