Elapsed time claculations

[GFH]

Hi All,

I been thru most of this newsgroup but can't quite put together the
answer..

I have two times and want to calculate the elapsed time between the
two.

No problem as long as I stay within the same day/24 hour period, but
ocasionally I may have a 20:30 start and a 01:30 finish with the
elapsed time formatted as [h]:mm

I normally just subtract the finish time from the start time formatted
as [h]:mm, but with the above example it of course doesn't work that
way..

Can one of you guru's sort this out for me..

what I need is....

Start Finish Elapsed

12:00 14:30 2:30
20:00 02:00 6:00



Thanks

 

[Bob Phillips]

see other post or even yesterday's.

--

HTH

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