If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Figuring military time for total hours
Helping someone out with a worksheet that figures time (in military
time) for use at weekend race tracks. Generally they have two days so it was easy with 2 IN's/2 OUT's for each day. But the rain at Daytona this weekend created a problem we did not expect. Someone starts work at Sat 0630 and finishes at 0130 Sun. Morning. Excel is not giving the total in correct hours, but I realize that's it's because you've gone to another day. As a workaround I told them for now to enter it as 2 days 0630 to 2400 and 0000 to 0130....is there a more elegant (or right) way to accomplish this? David |
#2
|
|||
|
|||
Entering the start/stop time as date and time should resolve your problem.
"David Nelms" wrote in message .. . Helping someone out with a worksheet that figures time (in military time) for use at weekend race tracks. Generally they have two days so it was easy with 2 IN's/2 OUT's for each day. But the rain at Daytona this weekend created a problem we did not expect. Someone starts work at Sat 0630 and finishes at 0130 Sun. Morning. Excel is not giving the total in correct hours, but I realize that's it's because you've gone to another day. As a workaround I told them for now to enter it as 2 days 0630 to 2400 and 0000 to 0130....is there a more elegant (or right) way to accomplish this? David |
#3
|
|||
|
|||
1. Excel can't gibe the time correctly since 0630 or 0130 are time formats,
to excel they are the numbers 630 and 130, you have to use formulas to make excel calculate as time http://tinyurl.com/78bwz where that example start time is in A1 and end time in B1 -- Regards, Peo Sjoblom (No private emails please) "David Nelms" wrote in message .. . Helping someone out with a worksheet that figures time (in military time) for use at weekend race tracks. Generally they have two days so it was easy with 2 IN's/2 OUT's for each day. But the rain at Daytona this weekend created a problem we did not expect. Someone starts work at Sat 0630 and finishes at 0130 Sun. Morning. Excel is not giving the total in correct hours, but I realize that's it's because you've gone to another day. As a workaround I told them for now to enter it as 2 days 0630 to 2400 and 0000 to 0130....is there a more elegant (or right) way to accomplish this? David |
#4
|
|||
|
|||
I meant they are not time formats and gibe should be give, doh!
-- Regards, Peo Sjoblom (No private emails please) "Peo Sjoblom" wrote in message ... 1. Excel can't gibe the time correctly since 0630 or 0130 are time formats, to excel they are the numbers 630 and 130, you have to use formulas to make excel calculate as time http://tinyurl.com/78bwz where that example start time is in A1 and end time in B1 -- Regards, Peo Sjoblom (No private emails please) "David Nelms" wrote in message .. . Helping someone out with a worksheet that figures time (in military time) for use at weekend race tracks. Generally they have two days so it was easy with 2 IN's/2 OUT's for each day. But the rain at Daytona this weekend created a problem we did not expect. Someone starts work at Sat 0630 and finishes at 0130 Sun. Morning. Excel is not giving the total in correct hours, but I realize that's it's because you've gone to another day. As a workaround I told them for now to enter it as 2 days 0630 to 2400 and 0000 to 0130....is there a more elegant (or right) way to accomplish this? David |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Adding Daily Time On Duty In a Query | RRLady | General Discussion | 6 | August 15th, 2005 12:32 AM |
Display elapsed time greater than 24 hours | mikelee101 | New Users | 2 | July 1st, 2005 12:04 AM |
Please Help! Ref Article ID 210504 | Telobamipada | New Users | 8 | May 9th, 2005 01:09 PM |
Change this formula for military time? | Matt | Worksheet Functions | 3 | July 27th, 2004 09:37 PM |
too complex for me! | RandyH | Setting Up & Running Reports | 8 | July 2nd, 2004 05:37 PM |