Forum Discussion

aharpole87's avatar
aharpole87
Copper Contributor
Apr 06, 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 06, 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.