Forum Discussion

cbrigham's avatar
cbrigham
Copper Contributor
Mar 05, 2020

Help calculating total hours worked times hourly rate

I'm trying to calculate total hours worked D7 x 14 (hourly rate) and have the $ amount result appear in E7

 

 

DateInOut# of Hours$14/hour
438920.3750.697916666666667=(C2-B2) 
438930.4583333333333330.583333333333333=(C3-B3)from home
438930.656250.729166666666667=(C4-B4)from home
438930.7916666666666670.875=(C5-B5) 
     
  TOTAL=SUM(D2:D6) 
 h:mm AM/PMh:mm AM/PM  

 

 
DateInOut# of Hours$14/hour
3/2/20209:00 AM4:45 PM7:45 
3/3/202011:00 AM2:00 PM3:00from home
3/3/20203:45 PM5:30 PM1:45from home
3/3/20207:00 PM9:00 PM2:00 
     
  TOTAL14:30 
 h:mm AM/PMh:mm AM/PM 

 

excel

7 Replies

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Mar 05, 2020

    cbrigham 

     

    Or to make the # of hours worked more clear, the formula should be:

    (C2-B2)*24

    formatted as number or general

    • cbrigham's avatar
      cbrigham
      Copper Contributor
      Mar 05, 2020

      PReagan 

       

      When I tried that formula the result is in Military Time which unfortunately is confusing to some here in the states. ğŸ™‚ Is there a way to remedy that? 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 05, 2020

    cbrigham 

    It's not clear where are D7 and E7, but it looks like in E7 it shall be

    =D7*24*14

    (1 hour in time format = 1/24 as the number) 

Resources