Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 667
- Office Version
- 365
- Platform
- Windows
Hi,
I need some help regarding time start / end calc.
I use this formula
=SUM(E28-F28)-H28
I have to input these times using the 24hr clock and allow for a 00:30 minute break . So when I enter :
(cell e28)Start time = 18:00
(cell f28)End time = 02:00
(cell h28) Break time = 00:30
In the the 'hours worked (cell c28) it should display '7:30'( which takes into account minus the 00:30min break), but instead returns 15:30? Can someone please show me what is required to give the correct result?
many thanks in advance
I need some help regarding time start / end calc.
I use this formula
=SUM(E28-F28)-H28
I have to input these times using the 24hr clock and allow for a 00:30 minute break . So when I enter :
(cell e28)Start time = 18:00
(cell f28)End time = 02:00
(cell h28) Break time = 00:30
In the the 'hours worked (cell c28) it should display '7:30'( which takes into account minus the 00:30min break), but instead returns 15:30? Can someone please show me what is required to give the correct result?
many thanks in advance