how to convert total hours (HH:MM) into decimal number

G

Guest

How can I convert total time (HH:MM) into a decimal (HH.MM)
Where 30 minutes (xx:30) equals .50.
So far I have the formula
=(INT(VALUE(O16))*24)+(HOUR(VALUE(O16)))+((MINUTE(VALUE(O16))/100))
but still need to convert minutes to decimal
 
P

Paul Corrado

With time in A1 (10:30 for example)

=A1*24 will yield 10.5

Note that time is already in decimal format in XL. The format option
displays the time as hours, minutes and seconds.
 

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

Convert 29.08 hours (shown in decimal form) to time shown in "hh:m 1
Convert decimal hours to hours:minutes 5
Decimal to Time Format. 5
Converting decimals into hh:mm 4
Change time h:mm to a decimal number based on hours 6
convert number to hh:mm 2
Convert [h]:mm sum total format to number format 1
How do I convert hours, minutes, and seconds into decimal format? 2

Top