how to convert 770mins to 12hrs 50mins
 

how to convert 770mins to 12hrs 50mins

how to convert 770mins to 12hrs 50mins
 

=A1/24/60, Format as Time

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"jisaugustin" wrote in message ...
| how to convert 770mins to 12hrs 50mins

how to convert 770mins to 12hrs 50mins
 

=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

"Niek Otten" wrote in message
...
=A1/24/60, Format as Time

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"jisaugustin" wrote in message
...
| how to convert 770mins to 12hrs 50mins