Yes. 1 is a day; 24 hours. So 0.5 is half a day; 12 hours. 0.75 is three
quarters of a day; 18 hours. Simply format the cells as time.

HTH. Best wishes Harald

"andrew pronto" .(donotspam) skrev i melding
...
Hi Harald
Thanks for info, however ie: say A1=18:00 shown by excel as 0.75, B1=06:00
shown as 0.25 if I apply your formulae I get 0.5?


"Harald Staff" wrote:

Hi Andrew

=B1-A1+(B1<A1)

HTH. Best wishes Harald

"andrew pronto" .(donotspam) skrev i melding
...
I want to calculate a period of time in 24 hours to be able to work
out
the
running speed of a machine. This is ok using say 18:00 to 21:00 the
resulting
time can be shown as a decimal & the machine output divided by the
result,
however how do I calculate the difference over the midnight period ie
say
11:30 to 02:00?
--
Andrew P.