Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time formula, complicated?
I'm trying to make a simple spreadsheat, in which i type in my work start and end time, then I have some cells that have time hours (07:00-21:00) at each cell it calculates whether it's time IE: 07:00 falls between the time entered, if it does it puts "XX" if not "--" the forula I use: Code: -------------------- =IF(G$2=$D3,IF(G$2<=$F3, "XX", "--"), "--") -------------------- And it works, so far but I want each "X" or "-" to represent thirty minutes, I just can't figure out the formula to tell if it is A the beginning of the shift and it begins at .5 make the mark be "-X" or if B it's the end of the shift and it ends at .5 make the mark "X-" See the image attached. Much obliged for any help you may provide -Thanks +-------------------------------------------------------------------+ |Filename: Shedule_Simple.png | |Download: http://www.excelforum.com/attachment.php?postid=4086 | +-------------------------------------------------------------------+ -- magecca ------------------------------------------------------------------------ magecca's Profile: http://www.excelforum.com/member.php...o&userid=29250 View this thread: http://www.excelforum.com/showthread...hreadid=489734 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula is entering a default time when it comes across an empty cell.. | Excel Worksheet Functions | |||
Formula TIME question | Excel Discussion (Misc queries) | |||
Formula to deduct unpaid breaks in time sheet | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Time Date Formula Problem | Excel Worksheet Functions |