Hi

With start and end times entered as times
=EndTime-StartTime+(EndTime<StartTime)
Format the result as time.

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"excelious" wrote in message
...
does anyone really know the answer to this cos i'm stumped. i've tried
everything.