| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Hours worked
I am trying to get total of hours worked useing military time....
time start time stop total hours 11:34 16:47 = How do i do this |
|
#2
|
|||
|
|||
|
Just subtract the two times and format the formula cell as
hh:mm. HTH Jason Atlanta, GA -----Original Message----- I am trying to get total of hours worked useing military time.... time start time stop total hours 11:34 16:47 = How do i do this . |
|
#3
|
|||
|
|||
|
Assuming your data isn in a2 and b2
=B2-A2 Lance "Keith Bowman" wrote: I am trying to get total of hours worked useing military time.... time start time stop total hours 11:34 16:47 = How do i do this |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding hours to a date | Excel Worksheet Functions | |||
| CALCULATE HOURS WORKED | Excel Discussion (Misc queries) | |||
| time-sheet record with over 24 hours | New Users to Excel | |||
| calculate average hours worked | Excel Worksheet Functions | |||
| Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Linear Mode
