TIme Calculation

New Contributor

Screenshot 2023-04-06 at 10.37.15 PM.png

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.

3 Replies

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

Screenshot 2023-04-07 at 06.09.42.png

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

best response confirmed by aharpole87 (New Contributor)






and format B1 as time.