[Solved] Hours registration

Discuss the spreadsheet application

[Solved] Hours registration

Postby tilburger » Mon Jun 23, 2008 12:26 am

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
Attachments
naamloos.ods
manuel and time file
(11.05 KiB) Downloaded 100 times
Last edited by Hagar Delest on Fri Aug 21, 2009 4:18 pm, edited 1 time in total.
Reason: tagged [Solved].
OOo 2.4.X on Ms Windows XP
tilburger
 
Posts: 2
Joined: Mon Jun 23, 2008 12:16 am

Re: hours registration

Postby acknak » Mon Jun 23, 2008 2:44 am

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.
Attachments
naamloos_edit.ods
(9.98 KiB) Downloaded 93 times
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: hours registration

Postby tilburger » Mon Jun 23, 2008 12:03 pm

yes this is some think i looking for.
OOo 2.4.X on Ms Windows XP
tilburger
 
Posts: 2
Joined: Mon Jun 23, 2008 12:16 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 26 guests