Remove time from another time

[#1]

Hello All,

Say I have a field called 'InTime'.

A pivot table then has the expression =TIME(InTime,'hh:mm')

What would I like is to have this time minus five minutes.

Any help would be much appreciated.

Regards,

Jim

[sreenivas]

=Time(TIME(InTime,'hh:mm')-Time('00:05','hh:mm'),'hh:mm')

[#3]

Hello Sreenivas,

Thank you for this.

I have not had time to test yet, but should be able to next week.

I will let you know how I get on.

Regards,

Jim