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?
Put a space before the AM or PM.
5:30 pm is in B1, and 6:45 am in A1
=B1-A1 format as h:mm, or as [h]:mm if you're going to need to sum values
beyong 24 hours.
Note that this may be uo to 30 minures different depending on the
Clock-on/Clock-off times.
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
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.