Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Night shift hours dilema
Hi, I am using this formula, but everytime I have no hours in my star
and finish cells, or if its 00:00, it gives me a 7.00, how can I mak this not do that. But instead make it a 0.00 rather, as I dont want m total of all the nightshift hours to show an amount if its not suppos to exist. =(IF(G14<TIME(7,0,0),TIME(7,0,0)-G14,0))+(IF(H14TIME(19,0,0),H14-TIME(19,0,0),0)) Thank -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Figuring Late night Hours | Excel Discussion (Misc queries) | |||
Total time vs hours per shift | Excel Worksheet Functions | |||
calculate finishing time if night shift aren't working | Excel Worksheet Functions | |||
Help: Trying to get hours for 11pm-7am shift | Excel Worksheet Functions | |||
Hours worked on job/per shift | Excel Programming |