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.
Time format in Excel
Name: Drewsey68 Date: January 11, 2007 at 23:20:58 Pacific OS: XP SP2 CPU/Ram: AMD1800/512DDR
Comment:
Hi all
I am trying to insert a 24hr time into a cell (eg. 0830 = 8:30am), but whenever I click out of the cell the following appears:
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 ...
Summary: http://www.computing.net/answers/of... I have got same issue in the link above, how can I change date format in Excel 2003 to dd/mm/yy (28/03/09),,,,there is no such an option in Format --> Cell --> "...
Summary: Hi, The formulas for conditional formatting that DerbyDad03 gave you do work in Excel 2007. Maybe you didn't enter them correctly. Excel 2007 has a load more options for conditional formatting than 20...
0 
