Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   How to calculate total hours from a given time in excel (https://www.askmehelpdesk.com/showthread.php?t=487129)

  • Jul 10, 2010, 05:24 PM
    venkatkurusar
    How to calculate total hours from a given time in excel
    How to calculate the total hours worked from the excel with the help of in time and out time
  • Jul 11, 2010, 08:54 AM
    JBeaucaire
    1 Attachment(s)

    A2 - TIME IN (in Excel time format: 8:00 AM)
    B2 - TIME OUT (in Excel time format: 4:30 PM)
    C2: =(B2 - A2) * 24 (formatted as General or Number)

    If you have to deal with shifts that go past midnight, you have to check for that.

    C2: =((B2-A2) + (A2>B2)) * 24

    Sample attached.

    • All times are GMT -7. The time now is 09:41 PM.