Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel (decimals and time)

Comment:

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

Name: Mike (by mmcconaghy)
Date: April 2, 2009 at 12:15:05 Pacific

Reply:

>>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/

0

Help with Dates in Excel ...

.EXE freezing problem

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I am trying to come up with a formula that will take 1/2/2009 6:30:00 PM (column C in Excel for Start Date & Time) and 1/3/2009 9:57:00 PM (column E in Excel for End Date and Time) and give me a tot...

Summary: I import dates and times from a database. The date imports as 010103 which is Jan 1 2003 and the time as 1200 which is 12:00pm. How can I get excel to do this conversion for me? I tried formatting the...

Summary: You have to open an instance of Access from Excel VBA and then open the database to make your changes. You should get a book on VBA if you don't have one already. John Walkenbach and John Green both ...