AM Hours to PM Hours

[Richard A.]

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.

 

[Nick Hodge]

Richard

If I understand you correctly, you can either have a formula (original PM
time in A1)

=A1+.5

Or you can copy .5 from a blank cell, copy the PM times and Edit>Paste
special..>Values+Add

..5 is equal to 12 hours

 

[Cecilkumara Fernando]

Richard,
This may be not a perfect solution, if the PMStart and PMStop are separate
columns you can add 12hrs or 0.5 to that columns
you can use pastespecial>Add for that
Cecil