TIme Calculation

[aharpole87]

 

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 A(ex: 8:30 AM)

Havent been able to figure it out. Any help would be greatly appreciated.

[#2]

@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.

[#3]

@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.

[#4 · Accepted solution]

@aharpole87 

Use

=MOD(A1-C1-D1,1)

and format B1 as time.