Converting minutes to decimal form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to be able to take a total amount of time, such as 4:45, and have it displayed with the minute portion in hundredths of an hour in decimal form. So, 4:45 would be shown as 4.75.
 
Multiply with 24 and format result as general or number

--

Regards,

Peo Sjoblom


BigAl said:
I'd like to be able to take a total amount of time, such as 4:45, and have
Click to expand...
it displayed with the minute portion in hundredths of an hour in decimal
form. So, 4:45 would be shown as 4.75.
 

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 Decimal fractions to binary and vice versa 1
Is there a simple formula to convert time in hundredths to minute 10
convert time to decimal 2
convert decimal numbers to a fraction of an hour for payroll hour 4
Converting hour/minutes to hours/hundredths 1
Decimal to time using number formatting only? 1
Convert decimal days to hours and minutes 2
Daily Time Sheets with Rounding 1

Back
Top