Help with time over two days please?

Giganews Newsgroups
Subject: Help with time over two days please?
Posted by:  Derek Peters (derek.pete…@btinternet.com)
Date: Wed, 12 May 2004

HI thanks for looking,

I have a sheet that I enter a start time into 12:30 PM (Cell formatted to
time (Cell A1)) and a finish time of 2:30 AM (Cell formatted to time (Cell
B1)) so I have worked a total of 14 hours.

Can you please give me a formula that will work over the two days and also
work if I start at 12:30 AM and finish at 10:30 PM on the same day IE 8
hours worked.

Many thanks for your help
Derek

Replies