| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Difference
Tried everything on this, I have two times in a spreadsheet.One is 05:15 and
the other is 08:17. I need the exact difference between the two in hours to three decimal places at least, so here it should show 3.033, instead all it ever shows is 3.00. I've tried the hours function and Int function without success. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Difference
=24*(A1-B1) and format as general
-- Gary''s Student - gsnu200738 "Dave" wrote: Tried everything on this, I have two times in a spreadsheet.One is 05:15 and the other is 08:17. I need the exact difference between the two in hours to three decimal places at least, so here it should show 3.033, instead all it ever shows is 3.00. I've tried the hours function and Int function without success. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
| how do I sum time difference | Excel Worksheet Functions | |||
| Negative time should be allowed in Excel, eg time difference | Excel Discussion (Misc queries) | |||
| Time zone Time difference | Excel Worksheet Functions | |||
| Time / Formula to look at time difference | Excel Worksheet Functions | |||
Linear Mode
