R
Rivers
hi is it possible for my graphs to display 35:01 rather than 11:01, the 1:01
is after it passed the 24 hour mark. i have the time originally stored as
1.45925925925926 in a table.
i used hoursandminutes([ATT]) to convert it to 35:01 but when i use this
valueon a pivot table it wont allow me to calculate the max it only allows me
to count which is useless, is there a work round for my graphs to show the
full hours and minutes value rather than the time equivalant 11:01
thanks again to everyone this forum site is excellant
is after it passed the 24 hour mark. i have the time originally stored as
1.45925925925926 in a table.
i used hoursandminutes([ATT]) to convert it to 35:01 but when i use this
valueon a pivot table it wont allow me to calculate the max it only allows me
to count which is useless, is there a work round for my graphs to show the
full hours and minutes value rather than the time equivalant 11:01
thanks again to everyone this forum site is excellant