Jul 04 2019 05:00 AM
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 with a colon, (60 number system as we see it on digital clocks).
I have a function "=(HOURS(A1)*60+MINUTES(A1))/60" that converts it the other way (from "08:15" to "8,25") maybe I just need to change this somehow?
Thanks
Tamás
Jul 04 2019 08:48 AM
Jul 04 2019 09:03 AM