That works only with side by side cells. not with two blank cells in between
for lunch in and lunch out. But it didn't work until I entered a negative
24, like =(B1-A1)*-12 Then it does give you the correct hours.
Thanks I learned something new, but can it be done with two cells between.
Or even with lunch in and lunch out times in between?


"Teethless mama" wrote:

A1: start time
B1: end time

=(B1-A1)*24


"lili" wrote:

example Punch in 6:45AM , Punch out 5:30PM

What formula can I use to add the total time worked by quarter hours? like
10.45