Total Hours / Min

[duvenhlc]

Good day all.

I have a database that consist of a task list and the time spent on these tasks. Two things, what is the best method to use as the input for the time duration of the task, it can vary from min or hours. I then need to total these hours. It does not seems like the normal date time format is the way to go since it relates to "clock" times.

Any suggestions.

 

[gemma-the-husky]

try the timer function

at the start

starttime = timer

at the end

endtime = timer
timer records seconds since midnight, so as long as the procedure doesnt overlap midnight, then the difference is the time in seconds

 

[duvenhlc]

Hi Gemma,

Whan I need is

Task Time
Task1 10 min
Task 2 1h10min
Task 3 30min

Total 1h50min

I need to give task a time and then calculate the total time of the combinned tasks. It will almost be similar to defining tasks in MS project.

Thanks

Lance

 

[DCrake]

The best way is to record the times in minutes and then sum up the mins then convert them to hours and mins afterwards.

David

 

[The_Doc_Man]

Concur with DCrake.

Note also that if you store the elapsed time in minutes, but then later convert it in a certain format (that I'll describe below), there is a way to get it to work. Sometimes.

You can store time as hh:mm in a date field. You are right that a date field has baggage. But if it makes it possible for you to work conventionally, just be careful and you might be able to get somewhere.

If you try to customize your total of the stored date fields, you need to remember this format specification: "hhh:mm" - which is a format that says "my answer isn't a date, it is an elapsed number of hours." You can then use the format function.

Alternatively, if you stored the elapsed minutes as an integer or long, you can convert that number directly to a date equivalent as CDBL( Minutes ) / 1440.0, which is then the number of days and fractions thereof that elapsed for the event. Store that in the date field or use the expression as the input to the Format statement for the value to be formatted when using that "hhh:mm" specification.

 

[duvenhlc]

Hi Guy's I have found a solution.

Look at this link from MS.

http://office.microsoft.com/en-au/access/HA011102181033.aspx?pid=CL100570041033

Cheers