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...
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).
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.