Results 1 to 2 of 2

Adding times

Threaded View

  1. #1
    Registered User
    Join Date
    11-30-2005
    Posts
    2

    Adding times

    I'm trying to add the following list of times:
    09:30 + 09:00 + 09:00 + 04:00 + 08:30 + 08:30 + 06:00 + 05:00 + 05:00 + 07:00 + 08:00 + 05:00 + 04:00 + 07:30

    Using the following formula:
    =IF(INT(ROUND(SUM(L4:L70)/0.04166667,2)) = 0, "", INT(ROUND(SUM(L4:L70)/0.04166667,2)) &":" & IF(MINUTE(MOD(SUM(L4:L70),1)) < 10, "0" & MINUTE(MOD(SUM(L4:L70),1)), MINUTE(MOD(SUM(L4:L70),1))))

    The problem lies in the part of the function marked in bold. This function is working perfectly with all/most other combinations of times.

    Hopefully someone can help me.

    Thanks,
    Imelda.
    Last edited by mel_flynn; 11-30-2005 at 07:41 AM.

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