That's because in time format 1 is evaluated as a whole day. If you
format the cell with

Format/Cell/Number/Custom [h]:mm

you'll see the 0:00 turn to 24:00.


In article ,
"Rob via OfficeKB.com" wrote:

Actually I found one of your post before and this works just fine

=INT(A1/60) + MOD(A1,60)/100

The problem I have now is the cell shows 1 for one hour instead of 1:00

I tried to format the cell to h:mm but the cell comes up as 0

Thanks for helping me out btw