#1   Report Post  
Old May 18th 05, 07:05 PM
quartz
 
Posts: n/a
Default 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   Report Post  
Old May 18th 05, 08:01 PM
Barb R.
 
Posts: n/a
Default

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   Report Post  
Old May 18th 05, 08:02 PM
Paul B
 
Posts: n/a
Default

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   Report Post  
Old May 18th 05, 08:07 PM
quartz
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUBTRACTING TIME VALUES INSTEAD OF DECIMAL!! Lexicon Excel Discussion (Misc queries) 8 April 19th 05 08:06 PM
Adding Subtracting Time Formula-Horse Racing SMDIYDLI Excel Discussion (Misc queries) 1 December 13th 04 09:27 PM
Subtracting time Pantryman Excel Worksheet Functions 6 November 24th 04 08:53 PM
Subtracting time in date format Collcat Excel Worksheet Functions 1 November 10th 04 09:40 PM
Subtracting time in date format Collcat Excel Worksheet Functions 1 November 10th 04 04:45 PM


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017