hotdogs1999
Board Regular
- Joined
- Dec 11, 2018
- Messages
- 57
hello,
looking to calculate the difference in time for 2 cells, and then reducing that total by the time in a 3rd cell.
e.g cell B4 is '7.30' and B5 is '17.30' and cell B6 is '0.30'
i want to find the difference between B4 and B5, and then remove the B6 value off that total.
fyi time format is hour.minute (don't need seconds in the format)
Thanks in advance
looking to calculate the difference in time for 2 cells, and then reducing that total by the time in a 3rd cell.
e.g cell B4 is '7.30' and B5 is '17.30' and cell B6 is '0.30'
i want to find the difference between B4 and B5, and then remove the B6 value off that total.
fyi time format is hour.minute (don't need seconds in the format)
Thanks in advance