| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
Floyd,
Since you need 36000 per hour, dividing by 36000 gives the number of hours. Dividing by 24 puts it into the time format that Excel uses, which is 1 = 1 day = 24 hrs. Bernie "Floyd Forbes" <(E-Mail Removed)> wrote in message news  9-dnS6E6K1-(E-Mail Removed)...> Thank you. It works, but why A1/36000/24 works? > > "Bernie Deitrick" <deitbe @ consumer dot org> wrote in message > news:(E-Mail Removed)... >> If the number of items is in cell A1, then >> >> =A1/36000/24 >> >> and formatted for time will show the time in hrs:mm:ss that it should >> take to run. >> >> HTH, >> Bernie >> MS Excel MVP >> >> >> "Floyd Forbes" <(E-Mail Removed)> wrote in message >> news:(E-Mail Removed)... >>> Help! >>> If a person require to run 36000 items per hour. How do I >>> show in excel converting 36000 to one hour using time format. >>> I tried 36000/60/60 = 0:00:00 did not work. >>> >>> Thanks >>> >> >> > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Thank you for your help.
"Bernie Deitrick" <deitbe @ consumer dot org> wrote in message news:uxnK$(E-Mail Removed)... > Floyd, > > Since you need 36000 per hour, dividing by 36000 gives the number of > hours. Dividing by 24 puts it into the time format that Excel uses, which > is 1 = 1 day = 24 hrs. > > Bernie > > "Floyd Forbes" <(E-Mail Removed)> wrote in message > news 9-dnS6E6K1-(E-Mail Removed)...>> Thank you. It works, but why A1/36000/24 works? >> >> "Bernie Deitrick" <deitbe @ consumer dot org> wrote in message >> news:(E-Mail Removed)... >>> If the number of items is in cell A1, then >>> >>> =A1/36000/24 >>> >>> and formatted for time will show the time in hrs:mm:ss that it should >>> take to run. >>> >>> HTH, >>> Bernie >>> MS Excel MVP >>> >>> >>> "Floyd Forbes" <(E-Mail Removed)> wrote in message >>> news:(E-Mail Removed)... >>>> Help! >>>> If a person require to run 36000 items per hour. How do I >>>> show in excel converting 36000 to one hour using time format. >>>> I tried 36000/60/60 = 0:00:00 did not work. >>>> >>>> Thanks >>>> >>> >>> >> >> > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Convert Time to Number | CRBI | Microsoft Excel Misc | 1 | 26th Nov 2008 03:52 PM |
| Convert time stored as decimalised number to time format | Emma | Microsoft Excel New Users | 1 | 29th Apr 2008 03:06 PM |
| convert number to time | =?Utf-8?B?SlI=?= | Microsoft Excel Worksheet Functions | 7 | 3rd Apr 2006 07:02 PM |
| convert decimal number to time : convert 1,59 (minutes, dec) to m | =?Utf-8?B?YWdlbmRhOTUzMw==?= | Microsoft Excel Misc | 8 | 20th Jan 2005 10:24 PM |
| convert a number to time | rbus | Microsoft Excel Discussion | 3 | 14th Jan 2005 05:37 PM |
