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 -- "The Year of 3" -2008- "Het jaar van 3" Cor Nouws - Arnhem - Netherlands > marketing contact - http://nl.OpenOffice.org > Zeker van OpenOffice.org - www.nouenoff.nl --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
