Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Date and time conversion in excel
Name: Jeff Date: April 3, 2003 at 21:36:52 Pacific OS: Office XP CPU/Ram: na
Comment:
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 cell as date/time but it reads the 010103 as the serial number for a date from 1994. Any thoughts?
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: Hi Bryan, Thanks for the reply, if only it was that simple. I know about the '####' when the data is larger than the cell, but this is what you also get when the cell contains a negative time value. ...
Summary: I hate time calculations in Excel. Here's what I tried. A1: 8:11 AM B1: 4:58 PM C1: =(B1-A1)*24-.5 Result: 8.28 Repeat that for 3 more working days. In C5 I put: =40-SUM(C1:C4)+0.5 Result: 7.37 Does ...
0 
Outlook 97 email (html / ...
