I didn't say what I really meant:

If as Chris says the time are ALWAYS overnight then:

If the times are ALWAYS the same day or overnght, (ie never more than 24
hours between the Start/End times), then the formulas will return the
elapsed time without adding dates.


--
HTH

Sandy

with @tiscali.co.uk


"Sandy Mann" wrote in message
...
You're not really going to get away without putting in the date,

If as Chris says the time are ALWAYS overnight then:

=MOD(Start Time - End time),1)

or

=Start Time - End time + (End Time < Start Time)

--
HTH

Sandy

with @tiscali.co.uk


"Anne Troy" wrote in message
...
You're not really going to get away without putting in the date, and
working around that (having the date and time in 2 separate cells) will
take someone better than me. :)
It looks like POA will also work out if you format the cells as [h]:mm.
And you cannot have a "negative" time, really, so you need to handle that
as well.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"Chris Watson"
wrote in
message news:Chris.Watson.2343jz_1139740202.9775@excelforu m-nospam.com...

Anne this is brilliant, your the headache tablet ive been looking for,
but I have a question ? is it possible to just type in the times in
Start and Finish without putting the date in, This timesheet is
designed for night shift work only so I will always start one day and
finish the next. Also there is one more problem thats bugging me and
that is if you look at cell U28, this is whats left of 48 hours POA in
a week, the law says that a driver of a HGV cannot exceed 48 hours POA
in a week and needs to know whats left. Cell L23 is the total POA of
the week so I need to take this figure away from 48:00, all I get is
#######.


--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile:
http://www.excelforum.com/member.php...fo&userid=4700
View this thread:
http://www.excelforum.com/showthread...hreadid=511313