Time

  • Thread starter Thread starter Brian Royston
  • Start date Start date
B

Brian Royston

Hi all

I have a database of which I have setup a query which sums a column to
return a total time in decimal.

My problem is I would like this in the following format i.e. 1234:00. But
every time I try to use Format it returns all kind of errors!

Any suggestions much appreciated.
 
Hi all

I have a database of which I have setup a query which sums a column to
return a total time in decimal.

Is this a Date/Time field, an integer count of minutes, or what?
My problem is I would like this in the following format i.e. 1234:00. But
every time I try to use Format it returns all kind of errors!

A Date/Time field is stored as a Double Float number, a count of days
and fractions of a day since midnight, December 30, 1899. I suspect
you're trying to apply a time format such as hh:nn to a Number - and
yes, it will give you very strange results if you're interpreting the
number as a number of minutes and Access as a count of days!

Try a formatting expression:

ShowDuration: [Minutes] \ 60 & Format([Minutes] MOD 60, ":00")

The \ is an integer divide operator.
 
Back
Top