Converting minutes to tenths

G

GordyB

I have a spreadsheet which requiers the time to be displayed as hr:mm am/pm,
I then need a subtotal (i.e. 8:00 AM to 11:45 AM) equals 3:45 (three hours
and 45 minutes) but the sheet has to show the subtotal as 3.mm in other words
three hours and then the minutes converted to tenths. Any suggestions.
 
×

מיכ×ל (מיקי) ×בידן

Hmmm..., I assume you want to convert "time" to "Tenth" because you want to
calculate costs
If my assumption is correct - you DON'T need to do so.
You should multiply the result by 24 and format the cell as "Currency".
Micky
 

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

Top