Hi:

I have a number in seconds that I need to convert to an HH:MM string
in Access SQL code. How to do?

Thanks,
Kayda

I found this on an older forum:

Format(Int([Field1]/3600),"00") & ":" & Format(Int(([Field1]-
(Int([Field1]/3600)*3600))/60),"00") & ":" & Format((([Field1] Mod
60)),"00")

and, that works, but I can't just remove the end bit (the "seconds"
bit) as that won't round my minutes(and hours where applicable) i.e.

170 seconds
=00:02:50
=00:02 using this formula
=00:03 using proper rounding

3599 seconds
= 00:59:59
= 00:59 using this formula
= 01:00 using proper rounding

How to do?

Thanks,
Kayda

On 26 May 2007 21:56:42 -0700, Kayda <(E-Mail Removed)> wrote:

>Hi:
>
>I have a number in seconds that I need to convert to an HH:MM string
>in Access SQL code. How to do?

[seconds] \ 3600 & Format([seconds] \ 60 MOD 60, "\:00")

This will discard the seconds. The backslash is an integer divide operator (or
a take-the-next-format-character-literally command).

John W. Vinson [MVP]