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.