=TIME(LEFT(A6,2),MID(A6,3,2),0)+(RIGHT(A6)="P")*0. 5

and format as time.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Cindy Smith" wrote in message
...
I was given a file that looks like this:

Day of Wk Time Number of Minutes
Tuesday 1148A 3
Tuesday 1151A 1
Wednesday 0301P 1
Sunday 1202P 5
Saturday 0530P 2
Monday 0542P 10

Trying to determin how many minutes were spent on the phone during
non-work
days/times (M-F, 8-5)

1. How do I convert the time into a useable format?
2. Please help w/formula