Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-22-2017, 10:59 AM
texascpa texascpa is offline If And conditions for Time Windows XP If And conditions for Time Office 2010 64bit
Novice
If And conditions for Time
 
Join Date: Sep 2012
Posts: 19
texascpa is on a distinguished road
Default Your help

The formula did not work and I think it is due to the way I have time formatted. I used the drop down menu in Excel and selected the format 13:30 which I thought was military time but times in my spread sheet less than 12 pm did not have 0 (e.g., 0930). The time in the cell was 9:30. I tried other formats and none work. Any thoughts?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum with conditions xling Excel 2 08-15-2017 12:16 AM
Sumif with Conditions Haha88 Excel 2 12-21-2016 12:08 AM
6 conditions formula paconovellino Excel 2 03-05-2012 06:45 AM
If And conditions for Time 3 Conditions Laurie B. Excel 4 08-15-2011 10:27 PM
how to set an equation with three conditions? Jamal NUMAN Word 0 07-09-2011 06:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:31 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