Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
No need to convert. Times are stored as fractions of a day (and displayed
according to the rules for time) so all calculations will work correctly. You may have to format your result explicitly as time. If times 24 hours are involved, format as [h]:mm to avoid tipping over at 24h "Leslie" wrote in message ... I need an average time, does Excel automatically do the correct computation (60 vs 100) if the field is formated as a time, or do I need to convert the times to numbers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
average of kth largest numbers in an array of n numbers | Excel Worksheet Functions | |||
Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
Average of Numbers in Top 5 | Excel Discussion (Misc queries) | |||
how i can make the numbers | Excel Discussion (Misc queries) | |||
How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) |