Hi Joe,
JOE Conner wrote (2-10-2008 1:15)
Cor Nouws wrote:
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
[...]
However
20:00 20:00 0O:00 25 0,0
I did some other trials, but am a bit lost here.
Incorporate a date along with the time, then the subtraction will always
work.
I thought about that. But I think the data will be visible as well, plus
that I do not want to bother people with entering the date.
Or do I miss something here?
I've created something with two helper columns in the mean time.
Something that works both in Calc and in Excel.
(I'm by far no spreadsheet expert. But would it be useful to post
something like that as an example on the OOo forum?)
Regards,
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]
