Time format

[John]

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

[Benny Andersen]

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

[John]

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