Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtracting Military Time
I have a timesheet that I enter in and out times for workers. This is all in
the same cell. Example: 1300-1515. In the next row i enter how many hours it is. We go by 1/4 hours. So in this case I would enter 2.25. I want to make the in/out times in seperate rows and have the difference calculated for me. When I do this, it comes out to 2.15 hours. I dont use a colon to seperate the time. Is there a way to calculate the difference so it shows each 1/4 hour(.25, .5, .75)? If B2 is 1300 and B3 is 1445, can a formula show the time as 2.75 hours? If I can do this without using a colon, I would prefer that. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
MEAN in Military Time | Excel Discussion (Misc queries) | |||
formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
Converting Standard Time into Military Time | Excel Discussion (Misc queries) | |||
Show timesheet time in and out in regular time versus military tim | Excel Worksheet Functions |