|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
07-23-2006, 02:09 AM
|
|||
|
|||
|
Time sheets
I have a new position and have been asked to assist in day sheets. I need to calculate how much time is spent in travel and services by line. One column will have begin time and the next column will have end time. I need to calculate the time spent on that item. I bought books on excel but don't think I have time to learn what I need to know in time to have the job on track. The column calculating the time spent will have to be in hour and minutes. Example: 3:15 (begin time) 4:00 (end time) the calculating column would read 45 (showing minutes) and if longer than minutes show 1hour and 45 minutes. I need to keep to hours since most employees do not relate to military time.
time is of the essence. Thank you Fbggirl 
|
|
#2
07-12-2007, 05:29 PM
|
|||
|
|||
|
Hi there.
Think this is what you are looking for. Main thing to remember is that when a time is entered into excel in hh:mm format that excel actually records that as a decimal number (12:00 is 0.5, 24:00 is 1). Therefore took the difference between the times and multiplied by 24 to get the difference (in integer form). I then had to separate the hours from the minutes using the left and right formulas. There may be a simpler way to do this mathematically, but I'm not sure. Let me know if this worked for you.
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
