Excel Time Calculation / Conversion

[Abdul]

i have a list imported from other database package.

The problem is:

1. I am applying Time format [h]:mm
but the figures format is not changing. Instead if i write the same
figure / numbers ie 3:30 manually, excel formats the numbers in time
[h]:mm.

How can i copy the information and change the format to [h]:mm?

I have to change the format because i have to calculate the time ie.
=sum(xxx:xxx)

Attachment filename: sample1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=423171

 

[JE McGimpsey]

I didn't open your workbook, but I'm certain that your values were
entered as Text. Copy an empty cell. Select your times and choose
Edit/Paste Special, selecting the Values and Add radio buttons. This
will coerce the text into numbers (which is how XL stores times - as
fractional days).

Format your time cells as desired.