Number | Minute | |
5/13/2010 15:31 | 31 | =MINUTE(D4) |
9:15:00 PM | 15 | =MINUTE(D5) |
0.02 | 28 | =MINUTE(D6) |
0.52 | 28 | =MINUTE(D7) |
1.52 | 28 | =MINUTE(D8) |
What Does It Do? |
The function will show the minute of the hour based upon a time or a number. |
Only the fraction part of the number is used as it is this which relates to time of day. |
|
Syntax |
=MINUTE(Number) |
|
Formatting |
The result will be shown as a normal number between 0 and 59. |
|
Example |
The =REPT() function has been used to make a digital display for the current time. |
The time functions of =HOUR(), =MINUTE() and =SECOND() have been used in conjunction |
with the =NOW() as the basis for the number of repeats. |
To update the clock press the function key F9. |
Clock | |
Hour | ||||||||||||||| 15 |
Minute | ||||||||||||||||||||||||||||||| 31 |
Second | |||||||||||||||||||||||||||||||||| 34 |
| =REPT("|",HOUR(NOW()))&" "&TEXT(HOUR(NOW()),"00") |
| =REPT("|",MINUTE(NOW()))&" "&TEXT(MINUTE(NOW()),"00") |
| =REPT("|",SECOND(NOW()))&" "&TEXT(SECOND(NOW()),"00") |
Related Information |
To convert a time in hh:mm format to decimal format. |
Enter a time in hh:mm format : | 2:45 | |
| | |
The same time converted to a decimal : | 2.75 | =F38*24 |
| | |
To extract the hours as a decimal : | 2 | =INT(F38*24) |
| | |
To extract the minutes as a decimal : | 0.75 | =MOD(F38*24,1) |
To convert a time in decimal format to hh:mm format.
Enter a time in decimal format : | 3.75 | |
| | |
The same time converted to hh:mm format is : | 3:45 | =F49/24 |
| | |
To extract the hours in hh:mm format : | 3:00 | =INT(F49)/24 |
| | |
To extract the minutes in hh:mm format : | 0:45 | =MOD(F49,1)/24 |
The three formula above have also been formatted as hh:mm using |
the Format, Cells, Number, Time command. |
Related Posts by Categories
Excel Notes- How to create a template in excel 2007?
- Tips for Setting Up a Table in Excel
- Table Terms in Excel
- Sorting Data in Excel (Sort Button and Sort Dialog Box)
- Separating Text in Excel (Separating the Data)
- Separating Text in Excel (Considerations)
- Hiding Columns, Rows, and Cells in Excel (Hiding Cell Contents)
- Hiding Columns, Rows, and Cells in Excel (Redisplaying Rows)
- Hiding Columns, Rows, and Cells in Excel (Hiding Rows)
- Hiding Columns, Rows, and Cells in Excel (Redisplaying Columns)
- Hiding Columns, Rows, and Cells in Excel (Hiding Columns)
- Find and Replace Features in Excel (Using the Replace Feature)
- Find and Replace Features in Excel (Using the Find Feature)
- Paste Special Feature in Excel (Paste Special Options)
- Paste Special Feature in Excel (Using the Paste Special Dialog Box)
- Using the Fill Command in Excel (Filling Cells, Filling Cells: Ribbon Option, Filling Cells: Mouse Option, Working with Custom Fills, Creating a Custom Fill, Importing Custom Fills, Using a Custom Fill)
- Working with Comments in Excel (Adding Comments, Adding Comments: Ribbon Option, Adding Comments: Mouse Option , Editing Comments, Editing Comments: Ribbon Option, Editing Comments: Mouse Option, Displaying/Hiding Comments, Displaying/Hiding Comments: Single Cell , Displaying/Hiding Comments: Ribbon Option, Displaying/Hiding Comments: All Cells , Moving Comments , Deleting Comments, Removing Comments from a Single Cell: Mouse Option, Removing Comments from a Single Cell: Ribbon Option, Removing Comments from All Cells, Printing Comments)
- Importing an External Data File in Excel
- Working with Rows and Columns in Excel (Adjusting Row Height and Column Width, Adjusting Row Height: Ribbon Option, Adjusting Row Height: Mouse Option, Adjusting Column Width: Ribbon Option, Adjusting Column Width: Mouse Option, Using AutoFit to Adjust Rows and Columns, Using AutoFit to Adjust Row Height: Ribbon Option, Using AutoFit to Adjust Column Width: Mouse Option, Using AutoFit to Adjust Column Width: Ribbon Option, Adding and Removing Rows and Columns, Adding Rows, Adding Columns, Deleting Rows, Deleting Columns)
- Calculating Subtotals in Excel (Adding Subtotals , Adjusting Views with Subtotals , To expand the view one level:, To collapse the view one level: , Removing Subtotals , Re-sorting the Data )
- Calculating with Functions in Excel (Parts of a Function , Inserting Functions, Inserting Functions: Dialog Box Option, Inserting Functions: Ribbon Option, About the Function Arguments Dialog Box, To access the Function Arguments dialog box:, Inserting Functions with the Point and Click Method, Adding Cells Together, Adding a Range of Cells with the SUM Function)
- Editing Cell Contents in Excel (Moving Information, Drag and Drop vs. Cut and Paste, Moving Information: Drag and Drop , To Undo Drag and Drop:, Moving Information: Cut and Paste , Copying Formulas, Copy and Paste )
- Working with Conditional Formatting in Excel (Applying Preformatted Rules , Applying Cell Highlighting , Applying Top, Bottom, and Average Rules , Applying Data Bars, Color Scales, and Icon Sets , Creating a Customized Rule , Editing Rules , Prioritizing Rules , Deleting Rules )
- Formatting Numbers in Excel (Formatting Numbers: Toolbar Option , Formatting Numbers: Ribbon Option , Formatting Numbers: Dialog Box Option , Clearing Number Formatting )
- Formatting Cells in Excel (Applying Cell Styles , Formatting Borders , Changing Borders, Changing Border Color , Changing Border Style , Deleting Borders , Using Conditional Formatting , Merging Cells , Creating a Cell Merge , Customizing a Cell Merge , Removing a Cell Merge , Wrapping Text, Copying Cell Formatting, Clearing Cell Formatting )
0 comments:
Post a Comment