changing time format in Excel

Copper Contributor

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

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

@tfulop 

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

 

Thanks