Forum Discussion
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 A(ex: 8:30 AM)
Havent been able to figure it out. Any help would be greatly appreciated.
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.
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.
