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?

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

Quote:

---

Originally Posted by JBeaucaire

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!