I want to convert time into numeric value and reverse, example 1) 01:00:00 into 1.0 or 2) 01:30:00 into 1.5 Is any function or any method available to do the same.
You can try the datetoseconds and datefromseconds functions in the link editor and then divide or multiply. For your example the number of seconds in an hour, 3600, would work.
Thanks for your reply. I found another way to do that, if you have a time as 01:30 then separate 01 and 30 using string functions and divide that 30 by 60. So now we have two values 01 and 0.5, after adding these values we will get 1.5, which is a required output.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.