Fantastic formula needed
Posted by Robin on January 21, 2002 9:03 AM
Please help. I need a formula that will display the contents of a cell (A1) as hours and minutes. A1 itself contains a formula which calculates whether an employee is doing enough contract hours. Each unit in cell A1 represents 5 minutes so if A1 equaled 4 then that employee would be 20 minutes in credit. If A1 was equal to -20 then they would be 1 hour and 40 minutes in debt.
How can I enter a formula to split this into hours and minutes and also indicate the sign of A1..???
Thanks in advance,