need help

[charles marvin del mar]

Using the table below:
1. Use excel formula to show: Day, Month, Week (Week starts on a Sunday)
2. Convert everything to EST format
Manila Time
EST Format
FirstName
Date
Day
Month
Week
Time In
Date
Day
Month
Week
Time In
Employee 1
2/13/2015
2:40:00 AM
Employee 2
2/13/2015
12:47:00 AM
Employee 3
2/13/2015
12:21:00 AM
Employee 4
2/12/2015
11:53:00 PM
Employee 5
2/12/2015
10:39:00 PM
Employee 6
2/12/2015
10:12:00 PM
Employee 7
2/12/2015
10:09:00 PM
Employee 8
2/12/2015
10:01:00 PM
Employee 9
2/12/2015
10:01:00 PM
Employee 10
2/12/2015
10:01:00 PM
Employee 11
2/12/2015
9:57:00 PM
Employee 12
2/12/2015
9:53:00 PM
Employee 13
2/12/2015
9:51:00 PM
Employee 14
2/12/2015
9:48:00 PM
Employee 15
2/12/2015
9:39:00 PM
Employee 16
2/12/2015
9:38:00 PM

 

[NARAYANK991]

Hi Charles ,

Please upload a sample workbook with this posted data in it ; if I have to do it , I can only copy paste and do a Text to Columns , but this will still not guarantee that the data layout that results is exactly what you are using.

Secondly , if more than one member of this forum wishes to answer your question , all of them will probably have to go through the same steps to derive a solution.

Uploading a sample file will make it easier for others to help you out.

Narayan