Issues with my TimeStamp

[#1]

Hello Everyone,

I am trying to calculate a difference between 2 timestamps and I have issues to obtain values with ny Timestamp format.

What I want to end up with is a duration in hours between the minimum values of my first time stamp of the day and the last one so that i Can work with the number of actual working hours.
Here is my table. if you want to have a look at it.

Thx you very much already.
Alexandre BERNARD

[kavita25]

Your excel file is unable to open...Reattached the file.

Regards,

Kavita

[krishna20]

Hi try using floor,

((Floor((MP_TO_DT))-(Floor(MP_FM_DT))))

[kavita25]

You can Use Interval function...

(Interval((MP_TO_DT)-(MP_FM_DT),'h:m'))

Somewhat lyk dis..for futher understanding..attached the document.

Regards,

Kavita

[maximiliano_vel]

First you will need to convert your TIMESTMP to TimeStamp format and the date Fileld Date to.

TimeStamp(Date#(TIMESTMP, 'MM/DD/YYYY-hhmmss')) as TIMESTMP

Date(Date#(Date, 'YYYY-MM-DD')) as Date

The part i don't understand is:

What I want to end up with is a duration in hours between the minimum values of my first time stamp of the day and the last one so that i Can work with the number of actual working hours.

Could you please elaborate?

[#6]

First of all thank you everyone for your answers !

What I meant Maximiliano  is to be able to measure the duration between the 1st timestamp of the day and the last of the same day. With this duration I would be able to know how much hours of work there were actually during one day.

[maximiliano_vel]

Please see attached file and tell me if this is what you need. Regards

[kavita25]

Hi,

Check the qvw

Hope it helps you..

Regards,

Kavita