Time - formatting

[CraigG]

I have a spreadsheet which in its basic format contains the number of hours a supplier has worked...

.........A..........B..........
1.......ABC......01:25
2.......DEF.......23:50

Column B is formatted as custom hh:mm

If I enter more than 23:59 hours it changes it to something I don't recognise, for example, 35:00 (ie 24 hours) becomes 11:00, or 50:00 becomes 02:00. I need it to show the true hours and minutes.

Similarly if I add up the total of column B it shows (for above) - 01:25 + 25:50 = 01:15

I think it's working in terms of hours/minutes of a clock/time - rather than letting me put in a number of hours/minutes.

I don't want to have to convert it to decimals as I need other users to key in actual time. Also another formula then calculates how much per hour, etc.

Can anyone help?

Thanks.

Craig[/code]

 

[GlennUK]

Format the cells as [hh]:mm to show more than 24 hours.