PDA

View Full Version : Convert time into decimals in excel worksheet


vks64
Apr 5, 2013, 10:42 PM
Sir

How to convert the time factor into decimals in the excel sheet?
Please help me with a formula for that

For example

When the Time duration is 1:30:00 ( Time is 1 hour,30 minutes and 0 seconds and not clock time), it has to be converted as 90 minutes Or 1.30 hours and shown either as 90.00(in minutes) or 1.30 (in hours) in excel sheet!

Whether the conversion formula will also take care of the seconds factor available in the above time format?

JBeaucaire
Apr 6, 2013, 07:13 AM
1:30:00 hours converts to 1.5 in decimal format, not 1.3.

Time is a fraction of 1. Hours represent 24 pieces of the number 1 in decimal values. So to take a time value and convert to decimal value, you need only multiple it by 24 and change the FORMAT of that cell to decimal.

=A1*24

vks64
Apr 13, 2013, 08:47 AM
1:30:00 hours converts to 1.5 in decimal format, not 1.3.

Time is a fraction of 1. Hours represent 24 pieces of the number 1 in decimal values. So to take a time value and convert to decimal value, you need only multiple it by 24 and change the FORMAT of that cell to decimal.

=A1*24

Thank You Sir!