Converting time to decimal

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

Guest

Hi I have a cell with time in it - the cell is formatted to [hh]:mm what I
need to do is convert this so that instead of saying 32:15 to say 32.25 -
does anyone know how to do this - I would be so gratful!!

dawnyanne x
 
why would you want to? However, if you miltiply it by 24 you will get
the result you want (which is also why I wouldn't as any cell that
references it can simply multiply by 24 if required)
 
HI Aidan - you are an absolute star!!!! I have been trying to sort this out
for ages - what an idiot! I work for 3 companies - on hourly rates - some
have decimal spreadsheets others in time - trying to combine them all is a
nightmare - but not now - thanks to you. I can thank you enough xxxx
 
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 standard time to decimal time 2
Decimal numbers to time format. 5
Access Convert a decimal time to hours and minutes 2
Excel How To Convert Decimal To Inches 2
formula for decimal point 4
decimal time data entry 5
Time calculations? 5
Convert Decimal to Calendar Date 3

Back
Top