How to Convert Time into Number

[joethehoe]

Does anybody know how to convert:

TimeValue ({mo_agent_unit.tdTime}) to a number??

I seen a number of differnt ways to convert numbers to time but not back to a number.

something like 5:00:00am and 5:30:00am to 05 and 05.5

Help, Help!!

 

[pandpp]

How about:


numberVar intHours := Hour({VP_USERACCOUNT.PWDUPDATEDTM});
numberVar intMinutes := Minute({VP_USERACCOUNT.PWDUPDATEDTM});
numberVar intSeconds := Second({VP_USERACCOUNT.PWDUPDATEDTM});

intHours + (intMinutes / 60) + (intSeconds / 3600)



Peter.

 

[joethehoe]

Thanks pandpp