+ Reply to Thread
Results 1 to 3 of 3

Mod function with time formatted values

  1. #1
    Registered User
    Join Date
    10-31-2007
    Posts
    34

    Mod function with time formatted values

    Hi,

    I need to work out if there is any residual time left using 30 secs interval. For example, if I have "0:16:00" in A1 and in B1 I have "0:0:30", in C1 I input the following formula which produces a correct result of 0:

    =Mod(A1,B1)


    I'm stuck in using this function without using the cell references? I tried to input =mod(0:16/0:0:30) but XL didn't like it. Any idea anyone?

    Thanks in advance.

    Regards


    kp

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    Try using quotes, i.e.

    =MOD("0:16","0:0:30")

  3. #3
    Registered User
    Join Date
    10-31-2007
    Posts
    34
    Thanks Daddylonglegs and it works.

    Regards


    kp

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1