I am exporting a report from Crystal Reports because the time "in" and
time "out" fields are recognized as text fields in instead of time
fields. I am trying to get a total time. If I try to format the cells
as time cells it has no effect. Here is my example:
11:30 AM 12:30 PM
I use the =Left(a3,5) formula to drop the AM & PM off of the cell and I
am able to sucessfully get a time difference for all times that do not
cross the noon hour. I get the following result for times that do
cross noon:
11:30 12:30 ########################
where ########### should actually be 1:00
I realize the root problem is that the database we are pulling from
does not recognize the fields that have times as time fields. I am not
able to correct that so I hope Excel can help with this problem.
Thanks
Mark
--
Mark@Marc
------------------------------------------------------------------------
Mark@Marc's Profile:
http://www.excelforum.com/member.php...o&userid=28126
View this thread:
http://www.excelforum.com/showthread...hreadid=513665