ExcelBanter - Excel Cell Format

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

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

- - Excel Cell Format - 2 (https://www.excelbanter.com/excel-worksheet-functions/52763-excel-cell-format-2-a.html)

Excel Cell Format - 2

I am also interested in a time format that would easily allow me to track
standard hours in manufacturing. For example, Operation 123 used to build
Part ABC takes 3 minutes, Opertion 345 takes another 10 minutes for a total
time of 13 minutes. The total time with all (sub)assemblies takes 93 minutes.

I need an expression that would easily allow me to input the time. The
expressions found/used in MS Project are ideal (e.g. 1 minute = input of 1m).
Then the spreadsheet can rollup the time as required.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

Excel Cell Format - 2

In your example your total is 93 minutes. If this is the format you need,
then simply enter the data in each cell in the number of minutes and sum the
cells.

--
Ian
--
"RDE" wrote in message
...
I am also interested in a time format that would easily allow me to track
standard hours in manufacturing. For example, Operation 123 used to build
Part ABC takes 3 minutes, Opertion 345 takes another 10 minutes for a
total
time of 13 minutes. The total time with all (sub)assemblies takes 93
minutes.

I need an expression that would easily allow me to input the time. The
expressions found/used in MS Project are ideal (e.g. 1 minute = input of
1m).
Then the spreadsheet can rollup the time as required.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions