Results 1 to 10 of 10

can if then else be used in a formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-01-2012
    Location
    england
    MS-Off Ver
    Excel 2016 pro
    Posts
    772

    can if then else be used in a formula

    hi
    can you use if then else in a formula like
    if a1 07:00hrs is less than f1 08:00hrs then difference is1
    what im trying to do is our working day is 08:00 to 16:30, 0700=0800 is o/t1.5 but 00:00 to 07:00 is o/t2,else 08:00 to 16:30 is single ,so if I go to work at 06:00 I would have 1 at x2 and 1 atx1.5, and 8 hrs at normal time,how could this look in a formula have tried a few today but getting tied up in knots
    cheers colin
    Last edited by cfinch100; 10-14-2013 at 03:21 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

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