Subtract 1 hour from time

[Former Member]

Hi all,

i have a time field called from time. I need to subtract 1 hour from that.My from time is 15:00:00

i used this formula but not getting the result.I am getting 54000.Please suggest

{?From Time}-TimeValue (1)

[abhilash_kumar · Accepted solution]

Hi Divya,

If this is a datetime field then you can use this:

DateAdd("h", -1, {?From_Time})

If this is not a DateTime field, however is just a Time field, then you can use this:

{?From Time} - 60

Hope this helps!

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

The field is just a Time field,

I tried with below formula but i am getting 14.59

{?From Time} - 60

[abhilash_kumar · Accepted solution]

OK. Try this:

{?From Time} - 3600

-Abhilash

[Former Member · Accepted solution]

Thanks Abhilash,

It is working now

[former_member1358754 · Accepted solution]

Hi Abhi

I have column A as 10:00 ... i need to add column B with column a-30 which is 09:30 ?? could you please suggest

[Former Member]

Hi

Try this

DateAdd ("h", -1, DateTimeValue (2013,01,01,12,12,12))

Regards

Vivek