Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
Can any one please let me know how to convert the value hh:mm:ss into minutes or seconds
I am not exactly sure about your question, but checkout Interval function,which is used something like
For e.g. the expression =Interval( today()-(today()-2), 'hh:mm:ss')
will output 48 hours.
P.S: In case this is not what you are looking out for, please update some more details.
Hi,
Use
Hour(),Minute() and Second()
For details see in help menu.
Regards
Divya,
Try this:
=Interval(Date#('04-08-2012 05:11:11', 'DD-MM-YYYY hh:mm:ss') - Date#('04-08-2012 05:12:15', 'DD-MM-YYYY hh:mm:ss'), 'mm:ss' )
Thanks,
AS
HI
Hope this link helps to understand for conversion
= hour(now()) * 60 + minute(now()) give result in minutes
Re: hh : mm : ss format converted to hour (numeric) value
Hi All,
Thanks for your replies.
I tried this and it worked out for my requirement.
(Subfield([time_value],'hh:mm:ss'),':',1)*60*60)+
(Subfield([time_value],'hh:mm:ss'),':',2)*60)+
(Subfield([time_value],'hh:mm:ss'),':',3))
[time_value]×86400
Or
Frac([time_value])×86400
If it's a timestamp