AM and PM Time

[Richard A.]

I have a huge problem with my Excel spreadsheet and cannot
find an answer anywhere. Here is my situation.

I have a master spreadsheet that is populated from another
spreadhseet that is created and exported by an Access
database. The information in the Access database contains
information entered in by people on a web page that
requires them to enter a time sheet for each work week.

However, here lies my problem. On the web page, there are
fields specifically named AM Start, AM Stop, PM Start and
PM Stop. All a person has to do is enter 7:00 in the AM
Start field and 11:30 for the AM Stop field. The same
holds true when a person enters 12:30 for the PM Start and
5:00 for the PM Stop. As you can tell, I am having a time
problem when this information is exported to my first
spreadsheet that is linked to my master spreadsheet.

The master spreadsheet calculates the AM times correctly
(all I want to do is to find out how much is worked
between start and stop). But with the PM times, it
interprets the times entered as AM! For example, when a
person enters 1:00 for the PM Start time, Excel interprets
this as 1:00 AM! Doing research, the only way around this
is if people enter military time which is crazy!

How do I work around this problem? Are there any formulas
or some format I can apply to the cells that contain PM
Start and Stop times that will correctly compute my
times? Please help !!

Thanks a million.

Richard A.

 

[Andy B]

Richard

Type 0.5 (half a day in Excel) into an empty cell. Copy this and use
Paste/Special/Add onto the cells you wish to be PM. This will add half a day
to each one and make them PM times.

Andy.