# time entry

1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back