Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
30:55.2 It's listed under Format cells/Number Tab/Time.
I've never used it because I don't know what it does. I work with amounts of time frequently, and have always used the 37:30:55 by default. Is there a way to get Excel to list hours, minutes, then seconds in decimal format? Thank you! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
[h]:mm:ss.0
-- David Biddulph "kmccormic" wrote in message ... 30:55.2 It's listed under Format cells/Number Tab/Time. I've never used it because I don't know what it does. I work with amounts of time frequently, and have always used the 37:30:55 by default. Is there a way to get Excel to list hours, minutes, then seconds in decimal format? Thank you! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi
have you tried reformating as general? regards FSt1 "kmccormic" wrote: 30:55.2 It's listed under Format cells/Number Tab/Time. I've never used it because I don't know what it does. I work with amounts of time frequently, and have always used the 37:30:55 by default. Is there a way to get Excel to list hours, minutes, then seconds in decimal format? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
Converting a time format to a String format in Excel | Excel Discussion (Misc queries) | |||
How to format cells in Excel for time in format mm:ss.00 | Excel Worksheet Functions |