DateTime calculations

[New2VB]

Greetings Gurus,

I am having an issue summing/formatting a time value and hope you can help.

I have a manually edited field which contains a long-time value xx:xx:xx. I need to calculate the total of all the values in this field but, of course, hit the 23:59 barrier and get rolled over to 00:00 if I leave it in long-time format .

If I use "=Sum([FieldName])" then I get 1.29166666666667 as a total of 00:10:00 + 10:20:00 + 20:30:00 whereas it should read 31:00:00. I am assuming this equals 1.29 days but (without resorting to functions like dur2sec) what is the syntax required to get it to display as 31:00:00?

I have tried using

=Format([FieldName] Mod 24,"\:00")

as I can't use DateDiff due to not having a start- and end date to perform a calculation.

Any suggestions please?

 

[Galaxiom]

Format(DatePart("d",[fieldname])*24 + DatePart("h",[fieldname]),"00") & ":" & Format([fieldname],"nn\:ss")