Calculate time with minutes

[imran91]

Hi guys

I format the cells from B6 to I6 to h:mm and when I type minutes or hours, it doesn't show the number but it appears 0:00. Second, i make a cell (total time) that will add up the whole times from C6 to G6, but when I make a cell (end time) that will calculate from start time with the total time, it doesn't show the right hours. so anyone know how to fix this problems? I already attach a dummy file.

Thanks guys

[benishiryo]

hi imran. not sure if there are other ways, but you have to write time as:
1) 0:15
(for 15 minutes) or;
2) =15/60/24
because time is a expressed as a decimal in Excel.

with that, you can easily sum up in H6 as such:
=SUM(C6:G6)

End time would be:
=B6+H6

[imran91]

Hi benishiryo

Thanks..its work. maybe i just make a hard formula..