time entry

  1. C

    Counting Hours on a Employee Schedule Time Sheet

    Hey Team! I've read over a few different forums and haven't found the solution that has worked properly for me, so I'm hoping something can help me with this. I have an employee schedule that I need to be able to count the total amount of hours for each shift. If I can get a formula that...
  2. B

    Time Calculation Question for Excel

    A1 = 18:20:30 B1 = 130 C1 = ? I have a start time (A1) and duration in seconds (B1) and need a formula for C1 to display the new time if B1 were added to A1. In this case, the end time would be 18:22:40. Help, please.
  3. B

    Excel 2007 Event Handler and Time Entry problem

    I'm having trouble entering time without using ":" as a delimiter. I just watched the Mr Excel video on Event Handlers: http://www.youtube.com/user/bjele123#p/c/42/FVTB6ruazJU<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> ... and was psyched to...
  4. F

    Movie Times

    I would like to catalog my home movies. I need a formula that would make it easy to: 1. Input Time [Hour Minutes Seconds] without using ":" because I mostly use the number keypad for inputting. Maybe using the period "." as 1.38.24 = One hour, thirty-eight minutes and twenty-four seconds 2...
  5. brettr87

    Floor and Ceiling problem

    Looking for help adjusting my formula in column D (Ceiling) so that instances like D5 would read as 15:15:00 as opposed to 15:00:00. Help is greatly appreciated. Excel...
  6. S

    Whats wrong with my code?

    I am trying to use a code where I can double click in cell B, C, D and E and have it enter the time from my computer. It works ok...but I was wondering if there was a way that I can only limit it to a certain number of cells in those columns. For instance I only want it in cells B7:B13. and then...
  7. eschiesser

    Help with entering Time Data

    Hi all. I need to enter elapsed time data manually into an excel spreadsheet. For example, on paper, I'm looking at this: 125:27:32 I would like to be able to enter this as follows: 1252732 Without colons, to save time. I've searched for many solutions before actually asking, and most of...

Some videos you may like

This Week's Hot Topics