Recent content by acombest

Thanks. I FINALLY found what works. Here it is: Format([FieldName]/3600),"00") & ":" & Format(Int(([FieldName]-(Int([FieldName]/3600)*3600))/60),"00") & ":" & Format((([FieldName] Mod 60)),"00")

I have a field that is a monthly total of log on time by seconds. I need to convert to hh:mm:ss. I don't want days displayed, I want the hours to summarize. For example - 86412 Seconds should equal 24:00:12 but shows as 00:00:12. Here's what I'm using and its dropping the hours that it...