ExcelBanter - How do I convert run time(45,502h 30m) to number 45,502.5 ??

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I convert run time(45,502h 30m) to number 45,502.5 ?? (https://www.excelbanter.com/excel-worksheet-functions/88743-how-do-i-convert-run-time-45-502h-30m-number-45-502-5-a.html)

mgonzo

How do I convert run time(45,502h 30m) to number 45,502.5 ??

Using Excel, i have a machine run time log ex 45,502hours 30minutes, how do i
convert all values to number format (45,502.5)?

daddylonglegs

How do I convert run time(45,502h 30m) to number 45,502.5 ??

If your run time is an actual time then to convert to decimal hours just
multiply by 24 and format as a number - or is it text - in which case
can you give the exact format

--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=542285

All times are GMT +1. The time now is 02:19 AM.