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

  • Thread starter Thread starter Guest
  • Start date Start date
:

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)


---
 
Back
Top