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
|
|||
|
|||
Excel time calculation
Hello, would like some assistance with a time calculation. Need to calculate
the total hours spent for a time from where I have a day and time in Europe as a start time, and a day and time in Asia as an end time, taking under consideration that the end time is 7 hours ahead of the start time. Here are my fields: A1: Monday 9 (start day) B2: 16:00 (start time in military time) C1: Wednesday (end day in Asia) D1: 9:00 (end time in military time, plus 7 hours ahead of the start time). Goal: To calculate the total transit time in hours. Does anyone know? Thank you. Simon |
#2
|
|||
|
|||
Excel time calculation
Sorry only have minute
Suggest you check out Pearson's 'Times And Working Hours, Between Two Dates' http://cpearson.com/excel/datetime.htm#WorkHours And others he has listed http://cpearson.com/excel/topic.aspx Cheers Mark On Jul 11, 12:50 pm, STS wrote: Hello, would like some assistance with a time calculation. Need to calculate the total hours spent for a time from where I have a day and time in Europe as a start time, and a day and time in Asia as an end time, taking under consideration that the end time is 7 hours ahead of the start time. Here are my fields: A1: Monday 9 (start day) B2: 16:00 (start time in military time) C1: Wednesday (end day in Asia) D1: 9:00 (end time in military time, plus 7 hours ahead of the start time). Goal: To calculate the total transit time in hours. Does anyone know? Thank you. Simon |
#3
|
|||
|
|||
Excel time calculation
Did something go wrong with my last post? See http://cpearson.com/excel/datetime.htm#WorkHours Also http://cpearson.com/excel/topic.aspx On Jul 11, 12:50 pm, STS wrote: Hello, would like some assistance with a time calculation. Need to calculate the total hours spent for a time from where I have a day and time in Europe as a start time, and a day and time in Asia as an end time, taking under consideration that the end time is 7 hours ahead of the start time. Here are my fields: A1: Monday 9 (start day) B2: 16:00 (start time in military time) C1: Wednesday (end day in Asia) D1: 9:00 (end time in military time, plus 7 hours ahead of the start time). Goal: To calculate the total transit time in hours. Does anyone know? Thank you. Simon |
#4
|
|||
|
|||
Excel time calculation
How about entering the dates/times like this:
A1 = start = 7/7/2008 16:00 A2 = end = 7/9/2008 9:00 Then you can format those cells to display the weekday: Format as dddd m/d/yyyy h:mm They will display as: A1 = Monday 7/7/2008 16:00 A2 = Wednesday 7/9/2008 9:00 Then it's just a simple subtraction formula: =A2-A1-TIME(7,0,0) Format this cell as [h]:mm Result = 34:00 -- Biff Microsoft Excel MVP "STS" wrote in message ... Hello, would like some assistance with a time calculation. Need to calculate the total hours spent for a time from where I have a day and time in Europe as a start time, and a day and time in Asia as an end time, taking under consideration that the end time is 7 hours ahead of the start time. Here are my fields: A1: Monday 9 (start day) B2: 16:00 (start time in military time) C1: Wednesday (end day in Asia) D1: 9:00 (end time in military time, plus 7 hours ahead of the start time). Goal: To calculate the total transit time in hours. Does anyone know? Thank you. Simon |
Thread Tools | |
Display Modes | |
|
|