Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Format a cell to display decimal hours.
How do I format a cell to display decimal hours?
Instead of displaying 3:45 (for 3 hours, 45 minutes), which is one of the standard formats, I'd like to display 3.75 (hours). h.hh doesn't do it. The above is formatting for an elapsed time calculation (finish time minus start time). (On a "time card") Excel 2000. Will a later Excel do it for me? Some good source for a parsing function? Any good reference? Thanks, Fred Holmes |
#2
|
|||
|
|||
Fred,
Format the cell in #.## format and multiply your result by 24. http://HelpExcel.com "Fred Holmes" wrote: How do I format a cell to display decimal hours? Instead of displaying 3:45 (for 3 hours, 45 minutes), which is one of the standard formats, I'd like to display 3.75 (hours). h.hh doesn't do it. The above is formatting for an elapsed time calculation (finish time minus start time). (On a "time card") Excel 2000. Will a later Excel do it for me? Some good source for a parsing function? Any good reference? Thanks, Fred Holmes |
#3
|
|||
|
|||
You can't do it with a format alone. You'll need to multiply the
time value by 24 and format as #0.00. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Fred Holmes" wrote in message ... How do I format a cell to display decimal hours? Instead of displaying 3:45 (for 3 hours, 45 minutes), which is one of the standard formats, I'd like to display 3.75 (hours). h.hh doesn't do it. The above is formatting for an elapsed time calculation (finish time minus start time). (On a "time card") Excel 2000. Will a later Excel do it for me? Some good source for a parsing function? Any good reference? Thanks, Fred Holmes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display values in cell | Excel Discussion (Misc queries) | |||
How do I format a value when using it within a cell reference tha. | Excel Worksheet Functions | |||
Sumproduct help needed! | Excel Worksheet Functions | |||
Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |