+ Reply to Thread
Results 1 to 4 of 4

Strange Values-Subtract Time from Time Stamp - Donkey Ote

  1. 02-22-2011, 07:59 AM #1
    Ashraf1
    Ashraf1 is offline
    Registered User
    Join Date
    02-09-2011
    Location
    Durban, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    23

    Smile Strange Values-Subtract Time from Time Stamp - Donkey Ote

    Hi,

    I've used a circ ref formula to create a time stamp for 'time in' column when data is entered into 'attendant' column. This would help to minimise input errors.
    ....this works fine but has messed up calculations for 'time elapsed' and 'downtime' columns.
    Calculations in these columns work fine if I remove the circ formula and input time manually

    Thanks...
    Attached Files Attached Files
    Last edited by Ashraf1; 02-22-2011 at 08:35 AM.
    Reply With QuoteRegister To Reply
  2. 02-22-2011, 08:05 AM #2
    Blake 7
    Blake 7 is offline
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: Subtract Time from Time Stamp - Donkey Ote

    Is DonkeyOTE in your title the equivelent of Gotham Cites "Batlight"?
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/
    Reply With QuoteRegister To Reply
  3. 02-22-2011, 08:10 AM #3
    Ashraf1
    Ashraf1 is offline
    Registered User
    Join Date
    02-09-2011
    Location
    Durban, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Subtract Time from Time Stamp - Donkey Ote

    nope, just want the moderator 'Donkey Ote' to look at spreadsheet cos he's familiar with it
    Reply With QuoteRegister To Reply
  4. 02-22-2011, 01:53 PM #4
    Ashraf1
    Ashraf1 is offline
    Registered User
    Join Date
    02-09-2011
    Location
    Durban, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    23

    Re: Strange Values-Subtract Time from Time Stamp - Donkey Ote

    bump no response
    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