Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page A Formula that will change a time of day frame based on # of minutes in another column A Formula that will change a time of day frame based on # of minutes in another column
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 01-17-2018, 10:19 AM
xor xor is offline A Formula that will change a time of day frame based on # of minutes in another column Windows 10 A Formula that will change a time of day frame based on # of minutes in another column Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
I guess you will have to change the tt in the formulas in A3 and A4 to hh (two instances).
Attached Files
File Type: xlsx Test Agenda_2.xlsx (13.5 KB, 12 views)
Reply With Quote
  #2  
Old 01-17-2018, 12:24 PM
Squint Squint is offline A Formula that will change a time of day frame based on # of minutes in another column Windows 7 64bit A Formula that will change a time of day frame based on # of minutes in another column Office 2007
Novice
A Formula that will change a time of day frame based on # of minutes in another column 		 
Join Date: Dec 2013
Posts: 4
Squint is on a distinguished road
Smile
Thanks so much. This worked perfect
Reply With Quote
  #3  
Old 01-17-2018, 01:18 PM
xor xor is offline A Formula that will change a time of day frame based on # of minutes in another column Windows 10 A Formula that will change a time of day frame based on # of minutes in another column Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
If you want to have a.m. and p.m. then see the attached (remember again to replace tt by hh)

Be sure to avoid merged cells.
Attached Files
File Type: xlsx Test Agenda_3.xlsx (12.3 KB, 11 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
A Formula that will change a time of day frame based on # of minutes in another column Formula to format "I" column based on if "F" column row is not blank ravl13 Excel 3 08-22-2017 12:26 PM
Merging 2 different cells containing IF formula & change in cell values based on multiple time frame jay_excel Excel 0 07-29-2017 11:04 PM
A Formula that will change a time of day frame based on # of minutes in another column Time to digital minutes ogmium Excel 13 11-25-2016 03:26 AM
Help with Macro - copying formula to last line of data based on another column kidwispa Excel Programming 1 07-12-2015 05:01 PM
Change Resource Time vs. Duration when Updating Work column lylel Project 3 07-23-2012 06:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:25 PM.

Contact Us - Privacy Statement - Top

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