+ Reply to Thread
Results 1 to 2 of 2

Calculate period in day

Hybrid View

  1. 09-12-2007, 11:14 AM #1
    rich3101
    rich3101 is offline
    Registered User
    Join Date
    09-12-2007
    Posts
    1

    Calculate period in day

    Is there a formula/function that takes a time and stipulates if it is before midday or after?
    Reply With QuoteRegister To Reply
  2. 09-12-2007, 11:21 AM #2
    BigBas
    BigBas is offline
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Assuming your time is in A1, this formula should work:

    =IF(HOUR(A1)>=12,"After Midday","Before Midday")

    Let me know if that helps.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1