Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a field called stage the values is in hours I want to convert to seconds ? how can I do this?
Stage (in hrs)
2
4
45
678
I tried : stage*3600 as stage it is not giving the result?
anyone suggest
Thanks
Sonica
May be this
Time(Time#(Stage, 'h'), 'ss') as Stage_Seconds
or Num(Stage) * 3600
Hi ,
Try with second(stage) or second(stage*3600) as stage
May be this
Time(Time#(Stage, 'h'), 'ss') as Stage_Seconds
or Num(Stage) * 3600
thanks sunny I tried secondone