By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,672 Members | 1,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,672 IT Pros & Developers. It's quick & easy.

Time format

P: n/a
Hello,

I have a Access 2k report where I need to display a list of swim times as
m:ss.ss. The table has the times stored as a number, the number of seconds
in fact. For example the value in the table 120.25 should display as
2:00.25.

I've been trying the Format() function but Format(ActualSeed_time,"m:ss.ss")
where ActualSeed_time is 104.13 dispalys as 4:12.12 rather than 1:44.13.

It is midnight here and the swim meet starts in about 31 hours so if anyone
has an answer it would be greatly appreciated.

Thanks in advance,

Brent
Jun 1 '07 #1
Share this Question
Share on Google+
2 Replies

P: n/a
On Fri, 01 Jun 2007 05:22:21 GMT, John wrote:
I've been trying the Format() function but Format(ActualSeed_time,"m:ss.ss")
where ActualSeed_time is 104.13 dispalys as 4:12.12 rather than 1:44.13.
s=104.13
print int(s/60) & ":" & s-60*int(s/60)

--
Mvh
Benny Andersen
Jun 1 '07 #2

P: n/a
Used this based on your formula to add and hide zeros as well as round:

IIf(Int([ActualSeed_time]/60)>0,Int([ActualSeed_time]/60) & ":","") &
IIf(([ActualSeed_time]-60*Int([ActualSeed_time]/60))>=10,Round(([ActualSeed_time]-60*Int([ActualSeed_time]/60)),2),"0"
& Round(([ActualSeed_time]-60*Int([ActualSeed_time]/60)),2))

Thanks,

Brent
"Benny Andersen" <a.*********@gmail.comwrote in message
news:ey*****************************@40tude.net...
On Fri, 01 Jun 2007 05:22:21 GMT, John wrote:
>I've been trying the Format() function but
Format(ActualSeed_time,"m:ss.ss")
where ActualSeed_time is 104.13 dispalys as 4:12.12 rather than 1:44.13.
s=104.13
print int(s/60) & ":" & s-60*int(s/60)

--
Mvh
Benny Andersen

Jun 1 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.