Forum Discussion

aharpole87's avatar
aharpole87
Copper Contributor
Apr 07, 2023
Solved

TIme Calculation

  This is for Excel on a Mac Trying to figure out how to get the value for Column B in time H:MM AM/PM from Column D(ex: 10:00 HOURS) plus Column C(ex: 0:18 MINUTES) subtracted from Column ...
excel
Excel on Mac
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Apr 07, 2023

    aharpole87 

    Use

     

    =MOD(A1-C1-D1,1)

     

    and format B1 as time.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 07, 2023

aharpole87 Your picture isn't really telling much. What formula did you enter in B, for instance?

In the picture below you see an example of how it could work.

  • aharpole87's avatar
    aharpole87
    Copper Contributor
    Apr 07, 2023

    Riny_van_Eekelen honestly I've tried too many to count. B should be 10:12pm. That's the answer to whatever formula it ends up being. I just can't get there.

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Apr 07, 2023

      aharpole87 

      Use

       

      =MOD(A1-C1-D1,1)

       

      and format B1 as time.

Resources