Excel time function help please
I always cheat when doing time based calculations and go staright to decimal hours or use a number xxpointxx to represent a time which I subseqently convert to decimal using a TRUNC based formula to treat the hours differently to the minutes.
However this time I am linking a whole pile of figures into spreadsheet, but the originals are in HH:MM (xxcolonXX) format.
Help
Last edited by TimS; 5th September 2007 at 07:27.
Reason: correcting my dreadful typing