With 282.78 in A1, and minutes in B1, try this in C1:

=A1/(B1*1440)

Make sure C1 is formatted to Number!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


try
"mattc66 via OfficeKB.com" <u16013@uwe wrote in message
news:90492b7d80a9b@uwe...
I should have asked with this post, but would you know then how I would
calculate the cost per minute.

Example: 0:4474:18 cost $282.78 how would I calculate the cost per minute?

Gary''s Student wrote:
Format the cell as Custom [mm]:ss
Enter data as 0:4474:18

You still need the hours part for data entry
Hi All,

[quoted text clipped - 7 lines]
Thanks
Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via http://www.officekb.com