ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Adding Time (https://www.excelbanter.com/excel-programming/371069-adding-time.html)

JAMES GABEL

Adding Time
 

Hi Everybody,

I have been setting up a excell file,and was wondering if it i
posible to skip time. I want excell to multiply (time (*) Qty).
need it to skip from 5:30 pm to 6:00 am and also skip weekends.

Any help would be helpful.

Thanks,

James Gabe

--
JAMES GABE
-----------------------------------------------------------------------
JAMES GABEL's Profile: http://www.excelforum.com/member.php...fo&userid=3757
View this thread: http://www.excelforum.com/showthread.php?threadid=57403


raypayette[_54_]

Adding Time
 

This link might be useful:
http://www.cpearson.com/excel/DateTimeWS.ht

--
raypayett

-----------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...fo&userid=2956
View this thread: http://www.excelforum.com/showthread.php?threadid=57403


JAMES GABEL[_2_]

Adding Time
 

thanks for the help. THe site looks good

--
JAMES GABE
-----------------------------------------------------------------------
JAMES GABEL's Profile: http://www.excelforum.com/member.php...fo&userid=3757
View this thread: http://www.excelforum.com/showthread.php?threadid=57403



All times are GMT +1. The time now is 12:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com