Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have two times, as a field namely
START_TIME
10:40:00
END_TIME
11:45:00
DURATION_TIME
01:05:00
and i found the duration between those two..
Now i want to display this duration time as 01 hour : 05 minutes : 00 seconds
Can we add text in between time format or is there any other way to achieve this..
Thanks..
Hi Kishore,
Time(DURATION_TIME,'hh') & ' hour : ' & Time(DURATION_TIME,'mm') & ' minutes : ' & Time(DURATION_TIME,'ss') & ' seconds'
if your DURATION_TIME field is in text format, you have to try like below.
Time(Time#(DURATION_TIME,'hh:mm:ss'),'hh') & ' hour : ' & Time(Time#(DURATION_TIME,'hh:mm:ss'),'mm') & ' minutes : ' & Time(Time#(DURATION_TIME,'hh:mm:ss'),'ss') & ' seconds'
Hi Kishore,
Time(DURATION_TIME,'hh') & ' hour : ' & Time(DURATION_TIME,'mm') & ' minutes : ' & Time(DURATION_TIME,'ss') & ' seconds'
if your DURATION_TIME field is in text format, you have to try like below.
Time(Time#(DURATION_TIME,'hh:mm:ss'),'hh') & ' hour : ' & Time(Time#(DURATION_TIME,'hh:mm:ss'),'mm') & ' minutes : ' & Time(Time#(DURATION_TIME,'hh:mm:ss'),'ss') & ' seconds'
or you can try
subfield(Duration_Time,':',1)&' Hours : '&subfield(Duration_Time,':',2)&' minutes : '&subfield(Duration_Time,':',3)&' Seconds'
Regards