Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert 29.08 hours (shown in decimal form) to time shown in "hh:m
Please help with formula. I have a table that adds up (totals) a list of
"time" in decimal form, and I want to also show this total number in hours and minutes. I have tried the =TEXT(G26/24),"h:mm") This works if the total is under 24, but if my decimal number is 29.08, it converts it to 5:05, and it should be 29:05. I want to put the hh:mm convertion right underneath the decimal number. HELP / and Many Thanks!!! Nila |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert 29.08 hours (shown in decimal form) to time shown in "hh:m
Format as [h]:mm
or using text =TEXT(G26/24,"[h]:mm") -- Regards, Peo Sjoblom "Nila in Florida" <Nila in wrote in message ... Please help with formula. I have a table that adds up (totals) a list of "time" in decimal form, and I want to also show this total number in hours and minutes. I have tried the =TEXT(G26/24),"h:mm") This works if the total is under 24, but if my decimal number is 29.08, it converts it to 5:05, and it should be 29:05. I want to put the hh:mm convertion right underneath the decimal number. HELP / and Many Thanks!!! Nila |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert more than 24 hours time to decimal? | Excel Discussion (Misc queries) | |||
Convert time to number shown | Excel Discussion (Misc queries) | |||
Column of Text Shown = Total Times Shown? | Excel Worksheet Functions | |||
Named Ranges shown (or not shown) as blue means what? | Excel Worksheet Functions | |||
Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) |