Converting minutes to decimal form

B

BigAl

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.
 
P

Peo Sjoblom

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

Excel does not accept text format! 0
Mail Merge - displaying a conditional number of decimals 5
Subtracting time...again 2
Is there a simple formula to convert time in hundredths to minute 10
15 minute data to daily data 1
Converting hour/minutes to hours/hundredths 1
convert time to decimal 2
Decimal to time using number formatting only? 1

Top