![]() |
|
#1
|
|||
|
|||
|
I would appreciate any help.
I have a merged field as a whole number for example, 60, 90, 45, 30. I would like to convert that to hours and minutes, so the output would look something like this. 1 hr 1 hr 30 min 45 min 30 min Notice that if its 0 hours or 0 min then I don't need to output anything. Many thanks in advance |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Countdown of Days, Hours, Minutes and Seconds | Chris Waller | PowerPoint | 3 | 01-31-2022 03:22 AM |
| Calculating Total Hours & Minutes Worked | aaghd72 | Excel | 2 | 04-13-2019 03:32 AM |
| Outlook 2013 gives 12 decimals after the minutes/hours | Curious | Outlook | 0 | 11-23-2017 08:38 AM |
Trouble with absolute values and hours/minutes and formulas
|
dglazer | Excel | 2 | 07-28-2015 01:42 AM |
| How to transform hours into minutes in mail merge | ppochelon | Mail Merge | 1 | 09-29-2013 07:07 PM |