Remember Me?

#1
May 18th 05, 07:05 PM
 quartz Posts: n/a
Subtracting time

I'm blanking on this:

Take 7:30 AM and subtract 12:00 PM to get hours worked...
How can I put that in a formula and have it return 4.5?

TIA

#2
May 18th 05, 08:01 PM
 Barb R. Posts: n/a

First, you'll need to subtract the END TIME from the START TIME.

Let's say
Start time A1= 7:30 AM
End Time B1 = 12:00 PM

C1 = (B1-A1)*24 and format C1 to NUMBER with 2 decimal places.

"quartz" wrote:

I'm blanking on this:

Take 7:30 AM and subtract 12:00 PM to get hours worked...
How can I put that in a formula and have it return 4.5?

TIA

#3
May 18th 05, 08:02 PM
 Paul B Posts: n/a

quartz, 12:00 pm - 7:30 am x 24, format cell as general, like this
=(B1-A1)*24
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"quartz" wrote in message
...
I'm blanking on this:

Take 7:30 AM and subtract 12:00 PM to get hours worked...
How can I put that in a formula and have it return 4.5?

TIA

#4
May 18th 05, 08:07 PM
 quartz Posts: n/a

Okay, thanks!

"Barb R." wrote:

First, you'll need to subtract the END TIME from the START TIME.

Let's say
Start time A1= 7:30 AM
End Time B1 = 12:00 PM

C1 = (B1-A1)*24 and format C1 to NUMBER with 2 decimal places.

"quartz" wrote:

I'm blanking on this:

Take 7:30 AM and subtract 12:00 PM to get hours worked...
How can I put that in a formula and have it return 4.5?

TIA

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Lexicon Excel Discussion (Misc queries) 8 April 19th 05 08:06 PM SMDIYDLI Excel Discussion (Misc queries) 1 December 13th 04 09:27 PM Pantryman Excel Worksheet Functions 6 November 24th 04 08:53 PM Collcat Excel Worksheet Functions 1 November 10th 04 09:40 PM Collcat Excel Worksheet Functions 1 November 10th 04 04:45 PM

All times are GMT +1. The time now is 05:03 PM.