How do I subtract time spent for lunch when calculating daily hrs

[Guest]

 

[Max]

:

From your subject line:

Re: How do I subtract time spent for lunch
when calculating daily hrs

If your start and end times
are entered in say, A2:B2, for example

in A2: 7:00 AM
in B2: 6:00 PM

and in C2 is your lunch in minutes, eg: 45

then we could put in D2: =(B2-A2)*24-(C2/60)
Format D2 as general

D2 will return the daily hours less lunch
(in decimal time)


---

 

[Guest]

THANK YOU!!!!!!!!!!!!! I had to play with format but this worked so
well!!!!!!!!!!!!!!

 

[Max]

Delighted to hear it worked for you !
Thanks for the feedback ..