Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 11-27-2016, 12:51 PM
Bdcrawford Bdcrawford is offline Time formulas Windows 8 Time formulas Office 2016
Novice
Time formulas
 
Join Date: Nov 2016
Posts: 13
Bdcrawford is on a distinguished road
Default

@jefferybrown

that works great the way it is setup.

We use military time here though so the code changes back when entering the value in B2 so I assume the code time needs typed as military to achieve this?


one weird thing though is the first 3 cells in column H are italicized then the rest a different format.

thank you

Last edited by Bdcrawford; 11-27-2016 at 01:06 PM. Reason: add more info
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Time formulas Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time CPSmith Excel 1 03-26-2016 02:48 AM
Time formulas Time Stamps automatically changed to same time! hydrogyny Word 4 02-09-2015 08:57 PM
Time allotted minus time used with result in hour and minute esther6086 Excel 2 04-29-2014 05:03 PM
Time & Date Formulas in Graphs Ady_E Excel 5 11-15-2012 05:29 AM
IE Object: Run-time problem (the link is not clicked in run-time but not in step-in tinfanide Excel Programming 1 03-04-2012 12:05 AM

Other Forums: Access Forums

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


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