Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate hours between to separate dates and times
I need to work out the amount of hours between a finish time on one day and
the start time on the next day. In some cases the start time may not be until 2 days time. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate hours between to separate dates and times
Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you
want the mins as well) -- __________________________________ HTH Bob "Dave08" wrote in message ... I need to work out the amount of hours between a finish time on one day and the start time on the next day. In some cases the start time may not be until 2 days time. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate hours between to separate dates and times
Thanks Bob, But the problem is the times are on 2 separate dates e.g. finish
2/10/2008 0200 and start 3/10/2008 12.00 "Bob Phillips" wrote: Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you want the mins as well) -- __________________________________ HTH Bob "Dave08" wrote in message ... I need to work out the amount of hours between a finish time on one day and the start time on the next day. In some cases the start time may not be until 2 days time. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate hours between to separate dates and times
Since Excel stored dates as serial numbers, try =(A2-a1)*24 where 24
converts fractions of a day to hours best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Dave08" wrote in message ... Thanks Bob, But the problem is the times are on 2 separate dates e.g. finish 2/10/2008 0200 and start 3/10/2008 12.00 "Bob Phillips" wrote: Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you want the mins as well) -- __________________________________ HTH Bob "Dave08" wrote in message ... I need to work out the amount of hours between a finish time on one day and the start time on the next day. In some cases the start time may not be until 2 days time. |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate hours between to separate dates and times
Still with differente dates the given formula applies :
Format the 2 dates cells as : 3/14/01 1:30PM and the 3er date cell(result) as : [h]:mm:ss. If you mean different worksheets, then just right the worksheet name in form of the cell as ex: =A1-SHEET3!A2 "Dave08" wrote: Thanks Bob, But the problem is the times are on 2 separate dates e.g. finish 2/10/2008 0200 and start 3/10/2008 12.00 "Bob Phillips" wrote: Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you want the mins as well) -- __________________________________ HTH Bob "Dave08" wrote in message ... I need to work out the amount of hours between a finish time on one day and the start time on the next day. In some cases the start time may not be until 2 days time. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate hours between to separate dates and times
That doesn't impact my response one iota. Try it!
-- __________________________________ HTH Bob "Dave08" wrote in message ... Thanks Bob, But the problem is the times are on 2 separate dates e.g. finish 2/10/2008 0200 and start 3/10/2008 12.00 "Bob Phillips" wrote: Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you want the mins as well) -- __________________________________ HTH Bob "Dave08" wrote in message ... I need to work out the amount of hours between a finish time on one day and the start time on the next day. In some cases the start time may not be until 2 days time. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate hours between to separate dates and times
I found this option worked the best in resolving my delima. because I had the
finish and start dates and times in seperate coloums I had to first calculate them then subtract them. I then formatted them [hh]:mm Date in Column A and the times in Columns B =(A2+B2)-(A1+B1) "Bob Phillips" wrote: That doesn't impact my response one iota. Try it! -- __________________________________ HTH Bob "Dave08" wrote in message ... Thanks Bob, But the problem is the times are on 2 separate dates e.g. finish 2/10/2008 0200 and start 3/10/2008 12.00 "Bob Phillips" wrote: Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you want the mins as well) -- __________________________________ HTH Bob "Dave08" wrote in message ... I need to work out the amount of hours between a finish time on one day and the start time on the next day. In some cases the start time may not be until 2 days time. |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate hours between to separate dates and times
It does help if you give all the information at the start. You never
mentioned the separate cells. -- __________________________________ HTH Bob "Dave08" wrote in message ... I found this option worked the best in resolving my delima. because I had the finish and start dates and times in seperate coloums I had to first calculate them then subtract them. I then formatted them [hh]:mm Date in Column A and the times in Columns B =(A2+B2)-(A1+B1) "Bob Phillips" wrote: That doesn't impact my response one iota. Try it! -- __________________________________ HTH Bob "Dave08" wrote in message ... Thanks Bob, But the problem is the times are on 2 separate dates e.g. finish 2/10/2008 0200 and start 3/10/2008 12.00 "Bob Phillips" wrote: Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you want the mins as well) -- __________________________________ HTH Bob "Dave08" wrote in message ... I need to work out the amount of hours between a finish time on one day and the start time on the next day. In some cases the start time may not be until 2 days time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate total pay from pay rate times hours and minutes | Excel Discussion (Misc queries) | |||
How do I calculate dates and times, w/answer of days & hours | Excel Worksheet Functions | |||
Calculate hours and minutes between times when it goes past midnig | Excel Worksheet Functions | |||
Calculate number of hours between dates and times excluding Weekends | Excel Discussion (Misc queries) | |||
Need difference between two dates/times in hours | Excel Worksheet Functions |