Convert Mins to HH:MM format
Mins/1440
Would give the required output.. just format the cell to HH:MM
1440 = 24hrs * 60 mins
Subscribe to:
Post Comments (Atom)
Welcome to this blog... here you get some excellent short cuts for some difficult excel VBA programming logic.
Followers
Blog Archive
-
▼
2010
(39)
-
▼
March
(20)
- Draw Border for the common cell values
- How to Sum the Visible cells data from the filtere...
- How to clean the leading or trailing cell spaces i...
- Subtract the given no.of days from today
- How to compare dates in Excel Macro
- How to convert Column Number to Name
- How to find the last column
- How to count the number of rows in the filtered data
- Convert Minutes to HH:MM format
- Stop the screen flicker while running the macros
- How to enable Autofill handle in Excel
- Changing Case of a Text
- Some tips for using IF condition
- How to work with protected excel workbook
- Create a time delay in Excel macro code
- Toggle between multiple excels sheets using Macro
- Sum the visible cell values from the filtered range
- Realign sheets as per the current months calendar
- Filter IEX Schedule Adherence Data
- Search file from a specific folder
-
▼
March
(20)
About Me
Visitors Count
No comments:
Post a Comment