Convert Time to Number

[nsaray]

Hi

I have a time  field. I want to convert the time to a number like the below

22:01pm >22.01

15:00pm > 15.00

9:06am > 9.06

Can anyone help

Thanks

[amitchandak · Accepted solution]

@nsaray ,

if field is of time type

a new column

= format([time], "HH.MM")

or

hour([Time]) *100 + minute([Time])

[nsaray]

Thank you!

I had to update it to this and it worked, so thanks for the suggestion

(hour([Time]) *100 + minute([Time]))/100

[Anthonywork247]

This is the correct answer 

Time.Hour([Duration])+Time.Minute([Duration])/60

if you have 01:30:00

previous solution would give you 1.3 hours

my solution gives 1.5 hours