excel time format

[NaiLBoMB]

hi, im new to excell, and im wondering if there is a way i caan convert a time in a field into the format hours:mins rounding up the seconds from the format hours:mins:secs. cos no matter how i try, i just cant get it to round up the seconds


}-------------------------------------------------------{

"I don't need intelligent drugs Tom, because I don't know what they are."

-Space Ghost

 

[fneily]

Format a cell with Time format 13:30. In the cell put
=Round(A1*1440,0)/1440
where your time is in A1.

Neil