Hours to decimal hours

[mr_novice]

Hi all,

Sorry for my bad choice of subject. I have a time "stamp" on this format "343:36:12" - This is the result between two timestamps using "interval" function. I would like to have this in decimal form like this - 343,6. Is there an easy way to convert this?

Br

Cris

[anbu1984 · Accepted solution]

SubField(Time_Fld,':',1) & ',' & (Replace((SubField(Time_Fld,':',2)/60),'.','')+0)

[mr_novice]

Thank you Anbu. I did this because I may have negative numbers. I thought there might be a function for or a time-option for converting this...

=if(subfield(vInterval,':',1)<0,

  (subfield(vInterval,':',1)*-1+(SubField(vInterval,':',2)/60))*-1,

  subfield(vInterval,':',1)+ (SubField(vInterval,':',2)/60)

)