Submitted by jan_rifkinson on 2016/10/01 10:02
Haven't worked in InfoQube for a few years & couldn't find the info on the forum or in help files
I'm looking for a fast way to enter time only
Thank you.
 
Jan Rifkinson
Ridgefield CT
Win10 IQ v0.9.81

Comments

You can use this while in a cell :
Date & Time: "=now()" + Enter
Just Date: "=int(now)" + Enter

Jan, also if you look in the same database (File>New IQ Base with Sample Data), one of the grids shows a time tracking example.  There is a column for start and end time, if you click on them they select the current time.  Once both are populated, duration (column) is calculated automatically.  You can also manually enter a duration.
 
As far as "fast", personally if I want to enter a fast time entry that I don't feel it necessary to track in a dedicated grid, I go to the Done grid and enter it there.  You could also create a grid called "time tracking" and enter it there.
 
The time for child items will also roll up to the parent item.
 
Finally, you can use pivot tables to perform more advanced calculations such as all time entered for the week or month or whatever.  But I think that goes a little beyond your question.
 
p.s. You will just want to add the following columns to whatever grid you want to track time in:
- Start Time
- End Time
- Duration
 
 

[quote=jan_rifkinson]
I'm looking for a fast way to enter time only
[/quote]
 
Hi Jan,
Good to "see" you.
What do you mean exacty?
Date/time fields can be configured to show time (hh:mm:ss) only... is that what you want?
 
-
IQ geek
Windows 8.1
CPU: Intel i5 2.6ghz