| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Format and Calculate difference in time
Your problem is not formatting, it is data entry.
Always enter your times like: 05:00:00 and 14:00:00 The result should be 9:00:00 (9 hours, not 7, not 14) -- Gary''s Student - gsnu200908 "da" wrote: Hello Everytime I type the time in hours, I get time and date in the cell. And I can not calclulate the difference intime -From to. E.g. 0500 -1400 should count 7.00 and I get the result 14.00. I used the time format from the menu. Need Help, plz. thanks Hours Total From To Hours |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| how to calculate time difference in hh:mm:ss | Excel Discussion (Misc queries) | |||
| how do i calculate the difference in time? | Excel Worksheet Functions | |||
| Calculate time difference between cells | Excel Discussion (Misc queries) | |||
| How do I calculate Time difference from PM to AM | Excel Discussion (Misc queries) | |||
Hybrid Mode
