• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Convert time to decimals

V

vilhelm

New Member
I have my time in hours:minutes:seconds


0:57:55

1:00:00

1:01:51

2:44:20


But I want to have it in decimals. For example the first row would be about 0.97 hours and the last row about 2.75 hours.


Have tried http://www.consultdmw.com/excel-time-conversion.htm but the formatting part didn't work for me (maybe because I am, unfortunately, using excel for mac 2011).
 
Hi vilhelm..


I am not sure.. below function is available on MAC or not..

but EXCEL have a very useful and rare used formula.. try the below.


=CONVERT(A1,"day","hr")


Please confirm if its works.. otherwise we may need to follow same using logic...


Regards,

Deb
 
Vilhelm


As times are already a decimal number all you need to do is Multiply them by 24 (24 hours in a day)

Then format the cells as , or "0.00" etc


=A1*24

apply format as , or "0.00" etc
 
You must log in or register to reply here.
Back
Top