Oops. Nevermind, I spoke to soon. Unless I enter it the way you said, it
takes it as hours and minutes instead of minutes and seconds. So, I have to
enter it the way you said or it won't work.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''
ptaylor



"Paul (ESI)" wrote:

Awesome! Thanks, that works. You know something? I feel silly now, though. I
didn't even bother to try first, I just assumed it would need some kind of
formula to understand time. I found out, though, if I just type it in some
kind of time format, Excell calculates it as time. It even worked when I just
typed in 5:23 and 3:55.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''
ptaylor



"traineeross" wrote:

Instead of 5:23 and 3:55

write 00:05:23 and the same for 00:03:55

HTH

"Paul (ESI)" wrote:

I was wondering if anybody knows of a formula to allow you to do calculations
based on time. In other words, say I want to put a list of songs on a CD and
their durations. Then, I want to add up the durations to get the full time of
the CD, or my specific play list. So for example, using the information below:

Ghostbusters - Ray Parker Jr. --- 5:23 (Just a guess)
Phantom of the Opera Overture --- 3:55 (Another guess)

Instead of 8:78, I'd want to see 9:18

Can this be done? Any help would be greatly appreciated. Thank you!

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''
ptaylor