Countif Formula

[crazyd]

I am making a driving log for Drivers Ed students. I need to do a couple of things. (I'm fairly new to Excel).

First off, in E5 I have the start time. (This is in a time format like 1:00 PM)
In F5 I have the end time. (Also in the above time format) In G5 I have the total drive time. I need to have a formula figure the difference between GF and E5 and put the amount (in minutes in G5). Everytime I do it, it comes out weird.

Then in D5 thru D73 I have a Data Validation that puts in either Day or Night. So, I need a formula that checks to see if it says day or night and put the total Driven from the G column for all day in G75 and the total for all night in G76.

I hope I haven't confused everyone here. Can someone help me?

 

[PaddyD]

Hi - welcome to the board!

re your first question - there's some info in this thread that might help out:

http://www.mrexcel.com/board/viewtopic.php?topic=20831&forum=2&1

Once you've got that sorted, it should be fairly simple to to the second bit - use sumif though, not counif.

Post back with results / more info if you need anything else,

Paddy

 

[Brian from Maui]

I had some time, so I hope this helps.
Columns A and B are formatted for time.
Column C and E are custom formatted to [hh]:mm

Book1
	A	B	C	D	E
1	13:30	14:30	01:00	night	03:15
2	12:00	13:33	01:33	day
3	14:30	16:45	02:15	night
4	9:30	13:00	03:30	day	05:03
Sheet1

Sorry for jumping in Paddy, had some idle time!

 

[PaddyD]

Idle time, Brian - been at the kava again?

 

[Brian from Maui]

Paddy,

If I did, this is the LAST place I'd be!