Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-05-2025, 01:22 AM
MishkaGrizzly MishkaGrizzly is offline Convert whole number to hours and minutes and remove 0 hours or minutes Windows 11 Convert whole number to hours and minutes and remove 0 hours or minutes Office 2021
Novice
Convert whole number to hours and minutes and remove 0 hours or minutes
 
Join Date: Nov 2025
Posts: 4
MishkaGrizzly is on a distinguished road
Default Convert whole number to hours and minutes and remove 0 hours or minutes

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
Reply With Quote
 



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
Convert whole number to hours and minutes and remove 0 hours or minutes 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft