normal Need help with formulas

More
6 months 3 weeks ago #2026 by hopkinskmaber@yahoo.com
Replied by hopkinskmaber@yahoo.com on topic Need help with formulas
I am trying to figure out how to create a formula that will show me overlapping times.  Like I want to be able to see exactly what times overlap.  I am building a schedule for work and need to be able to see how many people will be there at certain times.
for example
06:00-14:00                                      2 @ 06:00-12:00 
06:00-18:00                                      3 @ 12:00-00:00
12:00-00:00                                      2 @ 00:00-06:00
14:00-22:00                                      
18:00-06:00                                      
22:00-06:00                                      

Please Log in or Create an account to join the conversation.

More
7 months 2 weeks ago #1972 by mehidy1437
Replied by mehidy1437 on topic Need help with formulas
What is the problem to use =TODAY()+6?

Please Log in or Create an account to join the conversation.

  • esraanoah95@gmail.com
  • esraanoah95@gmail.com's Avatar Topic Author
  • Offline
More
1 year 1 week ago #1727 by esraanoah95@gmail.com
Need help with formulas was created by esraanoah95@gmail.com
I'm trying to look for a formula that make a number add up everyday without me having to make any changes.
for example it a cell has the number 5 i want a formula that adds 6 to it everyday automatically.

kind of like the date update formula (TODAY() )but with numbers.


if you happen to know anything kindly contact me ASAP. my boss assigned this to me and I want to impress him.

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun