Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to convert 770mins to 12hrs 50mins
how to convert 770mins to 12hrs 50mins
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert displayed number to absolute value | Excel Discussion (Misc queries) | |||
Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions |