+ Reply to Thread
Results 1 to 10 of 10

Time Formatting

Hybrid View

  1. #1
    Registered User
    Join Date
    02-27-2025
    Location
    Alabama
    MS-Off Ver
    Office 16
    Posts
    7

    Re: Time Formatting

    Thank you so much for showing me how this can be done. I have taken on the project of teaching myself excel and I don't have to say how this has been such an enormous task. I have made a few changes to my little time tracker and so far, everything has worked out okay, except for the formula to populate the minutes into the correct category automatically like you have shown in your mock file. I have tried everything and spent so many hours on trying to get this to work in my sheet and I have hit a wall. I have attached a copy of the sheet that I'm working on. I'm trying to make it so that when I select a category, then the minutes that I spent from clock in to clock out, will automatically go into the correct place. You show how to do this in the mock file, but I just cannot seem to get that to work. If you have any suggestions on how I might be able to do this or maybe what I'm missing in the excel you sent, I would be forever grateful.
    thank you again so much
    Candy
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Custom Formatting Time Duration & Editing A Time Calculation
    By Dexter2 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 03-10-2024, 08:38 PM
  2. [SOLVED] Help to modify conditional formatting formulas that display on time and late based on time
    By Longbow 44 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-09-2023, 09:11 AM
  3. [SOLVED] Conditional Formatting - Time (Hours&Min) Greater Than or Less Than Time in Another Cell
    By Alan L 185 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-19-2022, 08:36 PM
  4. Formatting a total time entry and building a cumulative time formula.
    By TMc10 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-16-2012, 10:26 PM
  5. Replies: 3
    Last Post: 11-06-2012, 01:37 AM
  6. Replies: 4
    Last Post: 01-11-2012, 07:59 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