To All Excel Experts

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Harold Garcia

Board Regular
Joined
Jan 2, 2014
Messages
72
Also i would like to ask how can i highlight the cells or atleast count the number of days with time having within 9:45 PM to 5:45 AM.. For a graveyard pay...


Thanks...
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Harold,

In general, you'll get more answers if you describe your problem in words or use one of the tools to show bits of your worksheet within the post than if you just say 'help - here's a link to my file'. Some board members, me included, have an old-fashioned distrust of opening unknown files.
 

Harold Garcia

Board Regular
Joined
Jan 2, 2014
Messages
72
I'm sorry sir PaddyP... i cannot describe my problem since i cannot picture in mind how to do it... im sure that the file can be trusted or else you can banned me in this sites...
there's a word in the file that can elaborate my problem... Again sorry for my action..
 

Harold Garcia

Board Regular
Joined
Jan 2, 2014
Messages
72

ADVERTISEMENT

My first problem is how can i convert time in a text format to be converted in a hh:mm AM/PM format?
 

Harold Garcia

Board Regular
Joined
Jan 2, 2014
Messages
72
This is the exact format:

¦20:17 ¦ in General


I want to be in this format:


8:17 pm in Time format
 

Harold Garcia

Board Regular
Joined
Jan 2, 2014
Messages
72

ADVERTISEMENT

Another thing is, how can i match a data in another data which dont have the exact data...
 

Harold Garcia

Board Regular
Joined
Jan 2, 2014
Messages
72
Well I guess my post is a tough one...

I think i will start to manually check more than 100 employees for 6 months...

:(
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828

Harold Garcia

Board Regular
Joined
Jan 2, 2014
Messages
72
how will the data automatically transfer on my requested format to a certain employee only?

for example my name...
 

Forum statistics

Threads
1,137,060
Messages
5,679,387
Members
419,824
Latest member
Mercy kiara

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top