Forum Discussion
tfulop
Jul 04, 2019Copper Contributor
changing time format in Excel
Hi all, I would like to change a time in Excel that looks like this "4,00" (four hours) to this: "04:00" or "8,25" hours to "08:15". The first is with a comma (10 number system) the second is wit...
JKPieterse
Jul 04, 2019Silver Contributor
Hours are a fraction of a day, so divide your number 8,25 by 24 and then format the cell as time.