Converting HH.MM to TIME.

[#1]

Good Day,

     I have a TIME here but not formatted into time.

     Sample:

     15.13 late means 15 hours 13 minute late. how can i convert it into a TIME.?

Thanks.

[Anonymous]

interval(interval#('15.13','hh.mm'))

[nagaiank]

You may use

Interval(Interval#('15.13','hh.mm'),'hh:mm')

to get the time in HH:MM format.

If you need the internal representation of time for further calculation, you may use

Num(Interval#('15.13','hh.mm'))