Convert 29.08 hours (shown in decimal form) to time shown in "hh:m

N

Nila in Florida

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting time...again 2
Convert decimal hours to hours:minutes 5
How to convert time expressed as a decimal to actual hours or minu 8
convert time to decimal 2
how to convert total hours (HH:MM) into decimal number 1
Change time h:mm to a decimal number based on hours 6
Convert time format to a decimal 2
Calculating Elapsed Time 2

Top