Thats wrong, please ignore,
Apologies,
Alan.
"Alan" wrote in message
...
Try formatting as 'Custom'
[hh]:mm:ss
Enter the time elapsed as 15:30 or 68:25 etc,
Regards,
Alan.
"VeronicaO" wrote in message
...
Please help. I am entering minutes and seconds...i.e. 34:10 into a
worksheet to be charted. One column is number of calls, the other column
is
minutes and seconds. At the bottom of the column I need an AVERAGE of
the
total minutes and seconds. I've tried to format the cells for mm:ss but
it
seems to convert the time to hh;mm;ss? Any suggestions.....Please help
I'm
going crazy trying to figure this out.