A Formula that will change a time of day frame based on # of minutes in another column

		Microsoft Office Forums > Microsoft Excel > Excel
A Formula that will change a time of day frame based on # of minutes in another column

01-17-2018, 01:18 PM

xor

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,100

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

Test Agenda_3.xlsx (12.3 KB, 11 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
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:17 PM.