Time Sheets
I am trying to calculate a time sheet but I entered: =SUM(C4-D4)+(E4-F4) and I get a negative # for the total?! Can someone help me on this? Also, I want to convert my time to military time so when I type in a time it will automatically convert? My time sheets looks as follows TIME IN TIME OUT TIME IN TIME OUT TOTAL 8:45 AM 12:30 1:00 4:00 PM =SUM(C4-D4)+(E4-F4) 8:45 AM 1:30 2:00 5:00 PM =SUM(C5-D5)+(E5-F5) TOTAL HOURS WORKED -- smiller3128 ------------------------------------------------------------------------ smiller3128's Profile: http://www.excelforum.com/member.php...o&userid=25929 View this thread: http://www.excelforum.com/showthread...hreadid=393022 |
All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com