Entering and Adding Time

R

Ron737

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
 
S

Sandy Mann

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
[email protected]
Replace@mailinator with @tiscali.co.uk
 
Top