changing time format in Excel

Question

Hi all,&nbsp;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).&nbsp;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?&nbsp;Thanks&nbsp;Tamás

jkpieterse · Answer

Hours are a fraction of a day, so divide your number 8,25 by 24 and then format the cell as time.

kodipady · Answer

tfulop&nbsp;=TIME(0,A1*60,0)&nbsp; will convert decimal to time format.&nbsp;&nbsp;

tfulop · Answer

Thanks

Forum Discussion

changing time format in Excel

3 Replies

Resources