Time and lunch breaks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to subtract two times and automatically have it subtract .5
hours for a lunch break if it is over 5 hours? I'd like to do this all in one
cell. Any suggestions would be helpful!
 
That didn't seem to work. I have it set like this

G13 7:30 AM
G14 10:00 PM
G15 14.5

Do I need to have G15 formatted differently? It is general text now. Any
other suggestions would be great! Thanks!
 
if you want it as a number and g13 and g14 are formated as time
in g15
=mod(g14-g13,1)*24-if(mod(g14-g13)*25>5,.5,0)
this will allow you to go over midnight and still have the correct answer
 
Back
Top