(Msg. 1) Posted: Tue Sep 02, 2008 8:10 am
Post subject: Turning Decimal time into HH.MM.SS format Archived from groups: microsoft>public>access>reports (more info?)
I have a query setup which gives me cetain times in decimal format using
certain cod *24* within my query. I have based a report on this query but i
want to be able to show the decimal time into the time format above? I have
tried going into properties and use Long time, short time, medium time
without success. Any suggesions would be welcomed.
(Msg. 2) Posted: Tue Sep 02, 2008 9:45 am
Post subject: Re: Turning Decimal time into HH.MM.SS format [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
What properties? Where?
Have you tried using the Format() function on a "field" in your query
definition?
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Scott Graham" <ScottGraham RemoveThis @discussions.microsoft.com> wrote in message
news:BC07BCAE-135D-4D9E-8DDF-6CF7EC9BD58D@microsoft.com...
>I have a query setup which gives me cetain times in decimal format using
> certain cod *24* within my query. I have based a report on this query but
> i
> want to be able to show the decimal time into the time format above? I
> have
> tried going into properties and use Long time, short time, medium time
> without success. Any suggesions would be welcomed.
>
> Thanks
(Msg. 3) Posted: Tue Sep 02, 2008 9:46 am
Post subject: RE: Turning Decimal time into HH.MM.SS format [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
>>I have a query setup which gives me cetain times in decimal format using
certain cod *24* within my query.
What is "certain cod *24* "?
--
KARL DEWEY
Build a little - Test a little
"Scott Graham" wrote:
> I have a query setup which gives me cetain times in decimal format using
> certain cod *24* within my query. I have based a report on this query but i
> want to be able to show the decimal time into the time format above? I have
> tried going into properties and use Long time, short time, medium time
> without success. Any suggesions would be welcomed.
>
> Thanks
(Msg. 4) Posted: Tue Sep 02, 2008 2:44 pm
Post subject: Re: Turning Decimal time into HH.MM.SS format [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
?an unconfused bottom fish of appreciable size?
Jeff
"KARL DEWEY" <KARLDEWEY.RemoveThis@discussions.microsoft.com> wrote in message
news:11F80D3A-80FF-4976-91FB-F71EED59EE1A@microsoft.com...
>>>I have a query setup which gives me cetain times in decimal format using
> certain cod *24* within my query.
>
> What is "certain cod *24* "?
>
> --
> KARL DEWEY
> Build a little - Test a little
>
>
> "Scott Graham" wrote:
>
>> I have a query setup which gives me cetain times in decimal format using
>> certain cod *24* within my query. I have based a report on this query but
>> i
>> want to be able to show the decimal time into the time format above? I
>> have
>> tried going into properties and use Long time, short time, medium time
>> without success. Any suggesions would be welcomed.
>>
>> Thanks
(Msg. 5) Posted: Wed Sep 03, 2008 1:03 am
Post subject: RE: Turning Decimal time into HH.MM.SS format [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Sorry, never clearly explained. the expresion I am using within my query is
"Hours: Sum(([time elapsed]*24))". thus giving me the time elapsed as a
decimal e.g. 0.123 of an hour. Within my report I would like to change this
to Time format e.g. 10mins etc...
"Scott Graham" wrote:
> I have a query setup which gives me cetain times in decimal format using
> certain cod *24* within my query. I have based a report on this query but i
> want to be able to show the decimal time into the time format above? I have
> tried going into properties and use Long time, short time, medium time
> without success. Any suggesions would be welcomed.
>
> Thanks
(Msg. 6) Posted: Wed Sep 03, 2008 8:11 am
Post subject: RE: Turning Decimal time into HH.MM.SS format [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Post sample data that would be in [time elapsed].
What is the DataType of the field?
--
KARL DEWEY
Build a little - Test a little
"Scott Graham" wrote:
> Sorry, never clearly explained. the expresion I am using within my query is
> "Hours: Sum(([time elapsed]*24))". thus giving me the time elapsed as a
> decimal e.g. 0.123 of an hour. Within my report I would like to change this
> to Time format e.g. 10mins etc...
>
> "Scott Graham" wrote:
>
> > I have a query setup which gives me cetain times in decimal format using
> > certain cod *24* within my query. I have based a report on this query but i
> > want to be able to show the decimal time into the time format above? I have
> > tried going into properties and use Long time, short time, medium time
> > without success. Any suggesions would be welcomed.
> >
> > Thanks
(Msg. 7) Posted: Wed Sep 03, 2008 3:20 pm
Post subject: Re: Turning Decimal time into HH.MM.SS format [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Format(CDate(.123/24)"nn:ss")
OR .123 * 60
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
Scott Graham wrote:
> Sorry, never clearly explained. the expresion I am using within my query is
> "Hours: Sum(([time elapsed]*24))". thus giving me the time elapsed as a
> decimal e.g. 0.123 of an hour. Within my report I would like to change this
> to Time format e.g. 10mins etc...
>
> "Scott Graham" wrote:
>
>> I have a query setup which gives me cetain times in decimal format using
>> certain cod *24* within my query. I have based a report on this query but i
>> want to be able to show the decimal time into the time format above? I have
>> tried going into properties and use Long time, short time, medium time
>> without success. Any suggesions would be welcomed.
>>
>> Thanks
(Msg. 8) Posted: Thu Sep 04, 2008 6:01 am
Post subject: Re: Turning Decimal time into HH.MM.SS format [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Example of hours below whcih i want turned into HH:mm:SS format
> Format(CDate(.123/24)"nn:ss")
>
> OR .123 * 60
>
> '====================================================
> John Spencer
> Access MVP 2002-2005, 2007-2008
> The Hilltop Institute
> University of Maryland Baltimore County
> '====================================================
>
>
> Scott Graham wrote:
> > Sorry, never clearly explained. the expresion I am using within my query is
> > "Hours: Sum(([time elapsed]*24))". thus giving me the time elapsed as a
> > decimal e.g. 0.123 of an hour. Within my report I would like to change this
> > to Time format e.g. 10mins etc...
> >
> > "Scott Graham" wrote:
> >
> >> I have a query setup which gives me cetain times in decimal format using
> >> certain cod *24* within my query. I have based a report on this query but i
> >> want to be able to show the decimal time into the time format above? I have
> >> tried going into properties and use Long time, short time, medium time
> >> without success. Any suggesions would be welcomed.
> >>
> >> Thanks
>
All times are: Eastern Time (US & Canada) (change) Goto page 1, 2
Page 1 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other