hour count after midnight

[nicolas.schimpf@gmail.com]

Hi all,

Is there a way to calculate hour betwen eg.
23:00 and 01:00 after midnight.
it calculates correctly when I put 25:00 instead 01:00.

Is there another way???

Thanks for your help

[Bill Kuunders]

deducting F column from E column

=24*(IF(F16>E16,E16+1-F16,E16-F16))

--
Greetings from New Zealand
Bill K

<nicolas.schimpf@gmail.com> wrote in message
news:1139942262.685334.33350@g43g2000cwa.googlegroups.com...
> Hi all,
>
> Is there a way to calculate hour betwen eg.
> 23:00 and 01:00 after midnight.
> it calculates correctly when I put 25:00 instead 01:00.
>
> Is there another way???
>
> Thanks for your help
>

[Harald Staff]

Start time in A1, end time in B1. Duration:
=B1-A1+(B1<A1)

HTH. Best wishes Harald

<nicolas.schimpf@gmail.com> skrev i melding
news:1139942262.685334.33350@g43g2000cwa.googlegroups.com...
> Hi all,
>
> Is there a way to calculate hour betwen eg.
> 23:00 and 01:00 after midnight.
> it calculates correctly when I put 25:00 instead 01:00.
>
> Is there another way???
>
> Thanks for your help
>

[nicolas.schimpf@gmail.com]

Thanks you it works
Perfect