To All Excel Experts

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

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
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
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,171,464
Messages
5,875,665
Members
433,146
Latest member
MinhTrang

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