No that doesn't work unfortunately as that is what I thought would work
originally and had already formatted the cells to mm:ss. If I type
0:45, it displays 0:45 in the cell, but actually accepts that as 45
minutes and appears as 00:45:00 in the formula bar. If I type 1:10 it
accepts that as one hour and ten mins (01:10:00 in formula bar), but
displays it as 10:00 which in my spreadsheet would look like 10
minutes.

Regards, Julie


--
burrowsybobs
------------------------------------------------------------------------
burrowsybobs's Profile: http://www.excelforum.com/member.php...o&userid=24327
View this thread: http://www.excelforum.com/showthread...hreadid=379298