Converting time (over 24 hours) to decimal

  • Thread starter Thread starter kerry
  • Start date Start date
K

kerry

Could anyone tell me how to convert for example 59:42
(59hours :42minutes) to decimal format?

I have already used =HOUR(CELL)+(MINUTES(CELL)/60)
 

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
Need a formula for time conversion 7
Changing decimal time into 24 hour time and reverse 4
convert time 2
Convert dd:hr:mn:ss to Decimal number of hours 1
How do I convert more than 24 hours time to decimal? 3
Problem with converting decimal time to hours and minutes 6
Timesheet - Formula 3

Back
Top