Time Format

[DaGoon]

To All,

I am trying to display some data on a report. The control source is as
follows:

=Format("Total downtime: " & Sum([StopLength]*60/1440),"Short Time")

In fortunately the data ends up being displayed as:

"Total downtime: 1.9096412037037"

When I would like it to be displayed as follows:

"Total downtime: 21:49"

FYI- The data type for "Stop Length" is a number.

Any help is greatly appreciated, thanks!

 

[Vincent Johns]

You might try moving the first string out of the Format() function, as I
think it's bollixing the conversion. Try something like this:

"Total downtime: " & Format(Sum([StopLength]/24),"Short Time")

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.