With
start time in A1 in hh:mm:ss format
finish time in B1 in hh:mm:ss format
C1 formula:
=B1-A1-1/48
Format hh:mm:ss
Time is recorded as a decimal part of a day and thus 30 mins = 1/48 of
a day.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
message news:[email protected]...
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
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.
