"Ron Rosenfeld" wrote:

Of course, Excel is interpreting this as 9 hrs 18 min and not 9min 18sec; but
all you have to do is divide by 60, it it's important.

Yeah, it worked okay except for that. All I had to do was enter in the full
time (including 0 hours) the way traineeross said and it worked fine. Thanks
for your suggestion as well, Voodoodan. That actually probably will come in
handy for a future project, where it will be more beneficial for me to use
your suggestion instead.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

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



"Voodoodan" wrote:


Unfortunately, the following is only helpful if you don't mind putting
the hours and minutes in separate cells.

If this is ok then you could use these formulas to total:

HOURS
=INT((SUM(-[range of hour column]-)*60+SUM(-[range of minute
column]-))/60)


MINUTES
=SUM(-[range of hour column]-)*60+SUM(-[range of minute
column]-)-(-[cell where hours formula, shown above, is located]-*60)

Dan


--
Voodoodan
------------------------------------------------------------------------
Voodoodan's Profile: http://www.excelforum.com/member.php...nfo&userid=597
View this thread: http://www.excelforum.com/showthread...hreadid=395311