Convert dd:hr:mn:ss to Decimal number of hours

G

Guest

Hi all, can anyone help with how to convert days/hours/minutes/seconds of
time into a decimal number of hours.

I tried the INT command which I've used before for hours but it only
converts the hours in my original cell??

Thanks
 
J

JE McGimpsey

One way:

XL stores times as fractional days, so where A1 contains the dd:hh:mm:ss,

=A1*24

Format the cell as general or another number format.
 

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

Access Convert a decimal time to hours and minutes 2
Converting dd:hh:mm to [h]:mm not working. 3
How do I convert more than 24 hours time to decimal? 3
Timesheet - Formula 3
Problem with converting decimal time to hours and minutes 6
Convert decimal days to hours and minutes 2
Convert Figure to Time HH:ss 2
Convert a number to a time 4

Top