Extracting hours from time

  • Thread starter Thread starter Toby
  • Start date Start date
T

Toby

Hi All,
Sorry I seem to have a problem getting my thick head around
this.

I need to enter a starting time then a ending time i.e.. 4pm to 9.30pm, A
formula to calculate the amount of hours worked eludes me.

Slag me all you like! I can take it, But this is driving me Insane.
 
Let's assume your begin time is in A1 and your end time is in A2. I'm also
assuming for this example that your begin and end time occurs in the same
day.

First, format columns A -C to a TIME format. I prefer the one that reads
13:30.

In A1, you can enter "4 PM" or "16:00" or "4:00 PM"
In B1, enter "9:30 PM"
In C1, enter =B1-A1

If you need to include data for start on one day and end on another day,
you'll need to format A and B to a DATE format. I prefer the "3/14/01
13:30" format.

That should get you there.

Have a great day!
Barb Reinhardt
 
Toby,

it is simply a matter of subtracting the start time from the end time. If
you want the answer as time, format the result cell as time, if you want it
as decimal hours, multiply by 24 and format as General.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Back
Top