Entering and Adding Time
 

Can anyone help with the following problem in Excel 97

I would like to enter time as follows and total correctly in hours and
minutes
10:35
10:57
10:20
Total 31:52

However what I have to do is enter_10_shift:_35_etc
and this gives me the following
10:35:
10:57:
10:20:
Total 31:52:

I would rather not have the second set of colons

Any suggestions ?

Thank You

The only way that I can reproduce your problem is to format the cell as
hh:mm:
What format have you ste in the cell(s)?

--
Regards

Sandy

Replace@mailinator with @tiscali.co.uk


"Ron737" wrote in message
oups.com...
Can anyone help with the following problem in Excel 97

I would like to enter time as follows and total correctly in hours and
minutes
10:35
10:57
10:20
Total 31:52

However what I have to do is enter_10_shift:_35_etc
and this gives me the following
10:35:
10:57:
10:20:
Total 31:52:

I would rather not have the second set of colons

Any suggestions ?

Thank You