Excel 2007 question
-
I wasnt sure where to post this, and google has let me down in my searches. What i am trying to achieve is pretty simple. I have excel 2007. i have aspreadhseet where i am recording time. I start at 6 AM, so i enter that. i take a break at 12:30 PM, so I enter that in the next cell, so this is what i have: B----------C------------- 6 AM-------12:30 PM I have both set up as time fields, and all i want to accomplish is this: B----------C---------D--- 6 AM-------12:30 PM--6.5 I know it must be possible, but i seem to be asking just the wrong question in my searches.
______________________ Mr Griffin, eleventy billion is not a number...:wtf:
-
I wasnt sure where to post this, and google has let me down in my searches. What i am trying to achieve is pretty simple. I have excel 2007. i have aspreadhseet where i am recording time. I start at 6 AM, so i enter that. i take a break at 12:30 PM, so I enter that in the next cell, so this is what i have: B----------C------------- 6 AM-------12:30 PM I have both set up as time fields, and all i want to accomplish is this: B----------C---------D--- 6 AM-------12:30 PM--6.5 I know it must be possible, but i seem to be asking just the wrong question in my searches.
______________________ Mr Griffin, eleventy billion is not a number...:wtf:
does this link work http://www.cpearson.com/excel/datearith.htm[^]
Maximilien Lincourt Your Head A Splode - Strong Bad
-
does this link work http://www.cpearson.com/excel/datearith.htm[^]
Maximilien Lincourt Your Head A Splode - Strong Bad