Excel (decimals and time)

April 2, 2009 at 12:09:55
Specs: Windows XP
I have read the "posting" for converting time to decimals in Excel. Here's my problem- I have 2 spreadsheets linked together. The second spreadsheet "looks" at the first spreadsheete IF the first sheet means a certain criteria, then the second sheet will add a certain range (SUMIF) here's the problem- I am adding up time. I am not getting any where close to the correct number. Should I convert change to decmials and then convert to time? Please let me know if you have any suggestions-- Phyllis

See More: Excel (decimals and time)

Report •


#1
April 2, 2009 at 12:15:05
>>the second sheet will add a certain range (SUMIF) here's the problem- I am adding up time.

Try this in your SUMIF cell:


Format:
Cells:
Custom:

[h]:mm:ss

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question