General Discussion - Excel query / formula problem

Print Page | Close Window

Excel query / formula problem

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: General Discussion
Forum Description: General discussion and chat on any topic.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7134
Printed Date: 30 March 2026 at 1:12pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Excel query / formula problem

Posted By: stevem2003
Subject: Excel query / formula problem
Date Posted: 10 November 2003 at 8:18am

I am looking for a macro/formula that will work out the following;
all I really want is to split the time out of the Date and Time, so that End time minus Start time = time open
Trips divide by Time open = trips per hour

Start Date End Date &n bsp; Trips
08/11/03 04:59 08/11/03 12:59 332

Any clues, suggestions would be appreciated.

TIA
Steve

-------------
There's no point running if you're on the wrong road!

Replies:

Posted By: michael
Date Posted: 10 November 2003 at 11:41am

Just substract EndDate Cell from Start Date Cell and format that calculation cell as time

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: eksimba
Date Posted: 10 November 2003 at 5:01pm

Try this:

Trips per Hour Calculation

The final formula is =D2/(C2*24)

-------------
- eric

Posted By: stevem2003
Date Posted: 11 November 2003 at 2:32am

Many Thanks guys, it seems reasonably obvious now you show me how Clown

-------------
There's no point running if you're on the wrong road!