Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
TIME CALCULATION
Can some please tell me the formula on how to calculate hours worked. For
example IN 6:15AM OUT 12:30PM IN 1:00PM OUT 6:00PM. I FOUND THERE IS A SIMILAR ANSWER HERE THAT CAME FROM LARRY, BUT WHEN I TYPE THE FORMULA THAT HE PROVIDED IT DOES'NT CALCULATE TO TOTAL HOURS ALTHOUGH I ALREADY FORMATED CELL A TO D TO h:mm and CELL E FORMATED TO NUMBER WITH 1 DEC... ALSO SHOULD THERE BE AN hh:mm or just an h:mm? PLEASE HELP. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Sheet Calculation | Excel Discussion (Misc queries) | |||
#VALUE! in Time Calculation | Excel Worksheet Functions | |||
perform calculation only if current time is after 10 am | Excel Worksheet Functions | |||
"Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
time calculation excel | Excel Worksheet Functions |