Adding hour to Time

[BJSOON]

Hi, I am trying to add an hour to Time In. :

Time In	Time Out
14:37:20	23:59:00
01:30:11	19:00:50

Using the following formula I got this:

1+(tonumber(DateTimeFormat([Gate In],"%H"))
+tonumber(DateTimeFormat([Gate In],"%M"))/60
+tonumber(DateTimeFormat([Gate In],"%S"))/360)

New Time In

New Time In

15.6722222222222

2.53055555555556

The formula only works with String.  How do I convert this back to Time? Or is there a formula whereby I can simply add 1 hour to the Time In which is Time type.  Thank you. 

[JosephSerpis · Accepted solution]

Hi @BJSOON I mocked up a workflow that produces the output you describe you need to use a datetimeadd formula.

[BJSOON]

Thank you!  This works!  I always have trouble with the date/time formula...

[JBO]

I get a conversion error when I do this:

DATETIMEADD: "2000-01-01" is not a valid DateTime.

Is that normal? Is there a way to get rid of the conversion error?

Thanks