CatRoberts
New Member
- Joined
- Mar 29, 2016
- Messages
- 48
Hi all,
I'm trying to add a formula to my workbook to convert minutes to hours and minutes, so 120 to read 2:00 for example.
I've used a couple of different formulas: =X6/1440 and format [h]:mm and also =X6/(24*60) then format the cell as [hh]:mm
Every time I enter the formula into the cell X6, firstly I get a circular reference error, then it changes the formula to read: 29/04/1900 00:00:00 so my return is - 2880:02
I tried putting the formula into a different cell to remove the circular reference error but it's still changing the formula to 29/04/1900 00:00:00 when I press save.
I have no idea what I'm doing wrong?
Any advice?
Many thanks
Cat
I'm trying to add a formula to my workbook to convert minutes to hours and minutes, so 120 to read 2:00 for example.
I've used a couple of different formulas: =X6/1440 and format [h]:mm and also =X6/(24*60) then format the cell as [hh]:mm
Every time I enter the formula into the cell X6, firstly I get a circular reference error, then it changes the formula to read: 29/04/1900 00:00:00 so my return is - 2880:02
I tried putting the formula into a different cell to remove the circular reference error but it's still changing the formula to 29/04/1900 00:00:00 when I press save.
I have no idea what I'm doing wrong?
Any advice?
Many thanks
Cat