date and time

[#1]

Hi

I have date in mm/dd/yyyy format and time in hh:mm:ss format and now i want to make this as datetime.... could someone suggest me the solution.... after that i want to calculate days.hours between two dates of same type..... thanks in advance.

[m_woolf]

You should be able to add the date and the time to get the timestamp.

[Miguel_Angel_Baeyens]

Hi,

Elaborating on that, the following will work

=Timestamp(Date('01/01/2012') + Time('14:00:54')) 

I'm using fixed values, that you can change for the name of the date and time values, respectively.

Hope that helps.

Miguel