jPaulB
New member
- Joined
- Sep 26, 2013
- Messages
- 7
- Reaction score
- 0
- Points
- 1
- Location
- Moncton, NB, Canada
- Excel Version(s)
- Microsoft Office 2019
Hi Folks,
bgoree09 was good enough to provide this formula to calculate hours worked less a consistent 30 minute lunch break:
=(IF(B2>B3,1+(B3-B2),B3-B2)-(B4/60/24))*24
B4 represents a calculated span of time.
My issue is that B4 will be a consistent 30 minutes... but when I copy the formula to a range of other cells, Excel modify B4 to B5 and so on.
How could I change this formula to at least appear like this?
=(IF(B2>B3,1+(B3-B2),B3-B2)-30 minutes
This way, the constant will remain a cionstant.
Thanks again,
Paul
bgoree09 was good enough to provide this formula to calculate hours worked less a consistent 30 minute lunch break:
=(IF(B2>B3,1+(B3-B2),B3-B2)-(B4/60/24))*24
B4 represents a calculated span of time.
My issue is that B4 will be a consistent 30 minutes... but when I copy the formula to a range of other cells, Excel modify B4 to B5 and so on.
How could I change this formula to at least appear like this?
=(IF(B2>B3,1+(B3-B2),B3-B2)-30 minutes
This way, the constant will remain a cionstant.
Thanks again,
Paul