Cor Nouws wrote:
Hi *,
Working with times and numbers.
Column F is the result of hours*tarif
A B C D F
12:00 14:00 A-B 25 D*C*24
in fact, F13 holds =HOUR(C13)*D13+MINUTE(C13)*D13/60)
this for in case B is at the next day
Results C > 02:00 and F > 50, so this works fine.
However
20:00 20:00 0O:00 25 0,0
I did some other trials, but am a bit lost here.
Any advice?
Thanks,
Cor
Incorporate a date along with the time, then the subtraction will always
work.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
