Hoffman
Board Regular
- Joined
- Oct 19, 2007
- Messages
- 220
- Office Version
- 365
- Platform
- MacOS
Thanks in advance..
I have always gotten great help from this fantastic community...
I would like a way to subtract time amounts (not actual time of day) from 2 cells.
So A1 says 4 hours 12 min 8 sec
B1 says 2 hours 8 min 7 sec
and
c1 needs to be the difference?
C1 2 hours 4 min 1 sec (want excel to do, right now I am doing by hand)
so in short, in the cells I need to write the amount of hours min and seconds and then I need a way to find the difference in cells.
thanks very much and wishing terrifichealth for 2023
Barry
I have always gotten great help from this fantastic community...
I would like a way to subtract time amounts (not actual time of day) from 2 cells.
So A1 says 4 hours 12 min 8 sec
B1 says 2 hours 8 min 7 sec
and
c1 needs to be the difference?
C1 2 hours 4 min 1 sec (want excel to do, right now I am doing by hand)
so in short, in the cells I need to write the amount of hours min and seconds and then I need a way to find the difference in cells.
thanks very much and wishing terrifichealth for 2023
Barry