how to convert 770mins to 12hrs 50mins

N

Niek Otten

=A1/24/60, Format as Time

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| how to convert 770mins to 12hrs 50mins
 
B

Bill Ridgeway

=B1*60*60+C1*60+D1
will convert hours minutes and seconds in B1, C1 & D1 respectively to the
number of seconds

Cell B1 =INT(E1/60/60)
Cell B2 =INT((E1/60/60-B1)*60)
Cell B3 =E105-(B1*60*60)-(C1*60)
will convert the number of seconds in E1 to hours (B1) minutes (B2) and
seconds (B3)

You may like to modify this.

Regards.

Bill Ridgeway
Computer Solutions
 
Top