Time Formula

  • Thread starter Thread starter Chris Watson
  • Start date Start date
C

Chris Watson

Im trying to put together a formula that will deduct start time with
finish time minus 30 mins.
Can anyone help.
Chris
 
Hi Chris!

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]...
 
Hi Chris,

=B1-A1-TIME(0,30,0)

and format as time

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top