Time from TimeStamp

[manojkulkarni]

Hi everyone,

How to get hour part from given timestamp ? Hour should get round of to nearest value.

eg :01:35:21 -> "02"

00:21:45 -> 00

[its_anandrjs]

Hi,

Let me know this formats are in the HH:MMSS.

Regards

Anand

[its_anandrjs]

Hi.

If is is then do some thing this way

Time( Left([Column Name],2), 'hh')

Or

Time(Time#( Left([Column Name],2), 'hh'),'hh')

Regards

Anand