Cable Forum

Cable Forum (https://www.cableforum.uk/board/index.php)
-   General IT Discussion (https://www.cableforum.uk/board/forumdisplay.php?f=19)
-   -   Excel assistance required (https://www.cableforum.uk/board/showthread.php?t=33620595)

belgthierry 07-09-2007 13:13
Excel assistance required
 
Hello,

need some assistance with creating an excell formula based on the following :
if k2 is between 06:45:00 and 13:59:59 enter days in L2 or if K2 is between 14:00:00 and 21:29:59 enter Evenings in L2 or if k2 is between 21:30:00 and 06:44:59 enter nights in L2

thanks

Paul K 07-09-2007 13:23
Re: Excell assistance required
 
Homework?

ikthius 07-09-2007 14:06
Re: Excel assistance required
 
Quote:
Originally Posted by belgthierry (Post 34391650)
Hello,

need some assistance with creating an excell formula based on the following :
if k2 is between 06:45:00 and 13:59:59 enter days in L2 or if K2 is between 14:00:00 and 21:29:59 enter Evenings in L2 or if k2 is between 21:30:00 and 06:44:59 enter nights in L2

thanks
so your trying to put an if forumla in?????

ik

Acathla 07-09-2007 14:44
Re: Excel assistance required
 
IF(condition, if_true, if_false)

IF(condition, if_true, IF(condition, if_true, IF(condition, if_true, if_false)))

etc..etc..

Post what you think it is and I am sure someone will be more keen on assisting rather than just giving you an answer. I don't like people who don't even try :(

LSainsbury 07-09-2007 16:11
Re: Excell assistance required
 
Quote:
Originally Posted by Paul (Post 34391656)
Homework?
Got it in one!! Yay! Homework threads start!!! :D


All times are GMT. The time now is 01:01.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
All Posts and Content are © Cable Forum