Report Errors

[Work man]

I have a report error occurring, basically in the report downtime in minutes is being worked from a query which is taking the opened date and time and closed date of time of issues when there entered

I'm taking this downtime in minutes and in another text box in the detail section am converting it into DAYS:HOURS:MINUTES using the following source

=Format(Int([Text46]/60)/24) & ":" & Format(Int([Text46]/60) Mod 24,"00") & ":" & Format(Int([Text46]) Mod 60,"00")

The first three or four entries convert no problem producing the correct coversion, however after the fifth or so entry into the database the conversion doesn't happen and instead the text box will display recurring numbers i.e. 66666666666667 etc; the prev. entries remain unaffected.

Is there a problem with the above formula or am I missing something?

 

[boblarson]

How about this instead:

=Format(([Text46]\60)\24,"00") & ":" & Format([Text46]\60) Mod 24,"00") & ":" & Format(Int([Text46]) Mod 60,"00")

The backslash divider divides and gives you the whole number without a decimal (so you don't need a conversion on that).

 

[boblarson]

Oh, and make sure there are no nulls in the field or that can cause a problem. If there is, you'll probably need to use the NZ function to deal with it.

 

[Rich]

Whereabouts is Text46 on the Report?

 

[Work man]

Thanks Boblarson that worked great!