Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=Time(TIME(InTime,'hh:mm')-Time('00:05','hh:mm'),'hh:mm')
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