Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Convert time into decimals in excel worksheet (https://www.askmehelpdesk.com/showthread.php?t=742859)

  • Apr 5, 2013, 10:42 PM
    vks64
    Convert time into decimals in excel worksheet
    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?
  • Apr 6, 2013, 07:13 AM
    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
  • Apr 13, 2013, 08:47 AM
    vks64
    Quote:

    Originally Posted by JBeaucaire View Post
    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!

  • All times are GMT -7. The time now is 10:57 PM.