Need to convert hours and minutes to hours and tenths.

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

Guest

I have a spreadsheet that tracks time - I currently convert hours and minutes
by adding the hours and multiplying the minutes by 1.666667. example 8 hours
and 30 minutes - =8+.30*1.666667 - results in 8.50. I have to manually
enter this for all hours and minute I want to convert to hours and tenths. I
am looking for a formula that can be entered in a cell that will
automatically convert the hours and minutes computed in the previous cell to
hours and tenths.
 
An even easier way would be to multiply the time by 24 and format as
general

=A1*24
 
You must log in or register to reply here.

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

Converting minutes to tenths 2
Quarter Hour time conversions for timesheet 2
CONVERT HOURS AND MINUTES TO INT 3
Excel formula 2
I have 3053 minutes and I want to convert to hours and minutes 2
dividing a number into hours and minutes 1
Concerting total minutes to hours and minutes 7
Converting dd:hh:mm to [h]:mm not working. 3

Back
Top