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?
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?