dear members.
i find a lot of hours registrations but not the 1 i must have.
if i enter the normal hours its going nice but if i enter 17:00 start and the time i quit 3:00 i get the problem the programma give me issue511
i put here a old file maybe somebody can help me out.
Best regard kevin
[Solved] Hours registration
[Solved] Hours registration
- Attachments
-
- naamloos.ods
- manuel and time file
- (11.05 KiB) Downloaded 217 times
Last edited by Hagar Delest on Fri Aug 21, 2009 4:18 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
OOo 2.4.X on Ms Windows XP
Re: hours registration
The error you see is because you have specified a function "TIME" (in English), which requires three arguments (hours, minutes and seconds), and you have given it only one.
It seems you need to start with the basics and learn how Calc deals with times. You really have to understand what happens behind the scenes in order to do calculations on times and get sensible answers. I don't have a good reference for that just now; maybe someone else knows one, or I can try to find something if necessary.
In the meantime, maybe this example will help give you some ideas.
It seems you need to start with the basics and learn how Calc deals with times. You really have to understand what happens behind the scenes in order to do calculations on times and get sensible answers. I don't have a good reference for that just now; maybe someone else knows one, or I can try to find something if necessary.
In the meantime, maybe this example will help give you some ideas.
- Attachments
-
- naamloos_edit.ods
- (9.98 KiB) Downloaded 196 times
AOO4/LO5 • Linux • Fedora 23