timekeeping in excel

P

pms333

I've downloaded a timekeeping worksheet and I need to set the time in
quarters and to subtract lunch in/out times.. we keep time in quarter hours
and I need a formula that will keep time in quarter hours or 15 minute
intervals...
 
M

Myrna Larson

You can get the time difference by just subtracting the start time from the
end time. The units of the result are days. To convert days to 15 minutes,
multiply by 96 (24 hours * 4).
 
Top