Results 1 to 6 of 6

Calculation with timetable

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-16-2012
    Location
    Latina, ITALY
    MS-Off Ver
    Excel 2010--2016
    Posts
    947

    Calculation with timetable

    Good evening I would like your help for a formula that verifies if adding a certain time to another is over or less than 24 hours
    Example: in the attached file in B9 I 01.00
    if I add 06.00 (E2) we arrive at 07.00
    therefore less than 24.00 but the formula in F9 says true.
    While if I use 23,59,59 in G9 says false which is the right result.

    So I have to use 23,59,59 or another way to put 24?
    Thank you
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Attendance timetable
    By zeez36 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2015, 03:48 AM
  2. Timetable Management
    By Ben44k in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-07-2014, 02:14 PM
  3. Help with timetable
    By GloriaSunshine in forum Excel General
    Replies: 5
    Last Post: 04-02-2013, 06:28 AM
  4. school timetable
    By kipronopaul in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2013, 01:05 AM
  5. Meeting Timetable
    By slewis102 in forum Excel General
    Replies: 0
    Last Post: 01-14-2013, 07:44 PM
  6. Creating a timetable
    By Bizzielizzie in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-23-2012, 10:52 AM
  7. Timetable
    By realmfighter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-18-2009, 11:18 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1