Access Report - Time Formats

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Can anyone assist me with this please.

I have a report that I run in access which shows how much time has been used
by a group of people however the time formats do not allow the time to be
calculated over 24:00:00. For instance if they have spent 26 hours working
this is displayed in my report as 02:00:00 because access thinks the max time
is 24:00:00.

How can I make access display 26:00:00 in the report?

Matt
 
Mattg said:
Hi

Can anyone assist me with this please.

I have a report that I run in access which shows how much time has
been used by a group of people however the time formats do not allow
the time to be calculated over 24:00:00. For instance if they have
spent 26 hours working this is displayed in my report as 02:00:00
because access thinks the max time is 24:00:00.

How can I make access display 26:00:00 in the report?

Matt
Click to expand...
Count the datediff and you'll have a long time then divide it to have the
hours
--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it
 
You have to manually convert the number yourself,
and not use the built-in format.
 
Back
Top