Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,236
Default Automatic change for time constraint

You could change the < to a =


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"bong" wrote in message
...

Moreover, if there is a lunch break, say from 19:30-4:00 that shift,
there is a lunch break at 23:00-00:00 (User define its start time and
the matrix will update automatically). How can I update that? I know it
would be very complex of the formula.
Sorry for my poor programming skill.
Thanks
Bong


--
bong
------------------------------------------------------------------------
bong's Profile:
http://www.excelforum.com/member.php...o&userid=15087
View this thread: http://www.excelforum.com/showthread...hreadid=267228



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cells with time constraint Freshman Excel Worksheet Functions 4 March 10th 10 08:34 AM
How to change y axis automatic time range? Mike Charts and Charting in Excel 1 September 21st 06 07:06 PM
Automatic change for time constraint bong[_3_] Excel Programming 1 October 8th 04 07:09 AM
Automatic change for time constraint bong[_2_] Excel Programming 1 October 8th 04 06:07 AM
Automatic change for time constraint bong Excel Programming 0 October 7th 04 01:57 PM


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"