Hello,
I have a spread sheet where I have been recording the days / hours I have worked. I am also trying ti calculate the amount of holidays I have accrued.
However when I first started using excel I entered everything in decimal numbers and now I am struggling to convert everything to hours and minutes and seconds.
I have attached a demo spreadsheet, but basically I would like to know, if i have a cell that has a decimal 8 (cell A1) in it to represent 8 hours and another cell with the formula =A1*4.56 how do i get the result to be hours:minutes

test book.xls