Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert Time to Number

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
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous ,

    if field is of time type

     

    a new column

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

     

    or

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you!

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

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

Anthonywork247's avatar
Anthonywork247
New Member
4 years ago

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