H and welcome to the forum
Keep in mind that excel treats time as a fraction/decimal of 1 (day). So 12:00 mid day is actually 0.5, and 06:00am is 0.25.
30 minutes is either 0.0208333333333333 or 30/60/24
plug that into your formula and see how far you get
Another observation - if you are just adding (or subtracting) 2 numbers, you dont need to use the SUM() function.
=IF(C7>0,SUM(C7-B7),"0")
can be shortened to...
=IF(C7>0,C7-B7,0)
Last edited by FDibbins; 07-15-2013 at 02:32 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for the advice!
I used the formula =IF(C1<=TIME(6,0,0),C1,C1-TIME(0,30,0)) from the forum you linked me to, and it works great for subtracting the half houre. Now the only problem I have is that when someone is scheduled off, I have the formula calculating "0" in column D, but it's creating a problem in column F. It just shows "#######" in column F and it messes with the totaled hours for the day. So the total for Sunday is showing as 14:30 when it should be 16.
excel help2.xls
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
candrus 
Register To Reply
Bookmarks