var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a spreadsheet that has the hours I worked for a certain week. I have 3 columns. Start time, end time, and sum hours. How can I calculate my sum hours if I started work at 11:00 pm and finished at 7:30 the next morning?
You will have to put in dates for this
5/1/04 11:00 PM
5/2/04 7:30 AM
=(+B1-A1)*24 (you will need to format as general)
Thanks a bunch!!!
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors