How do i return hours and minutes between two days?

December 21, 2018 at 02:45:23
Specs: Windows 7
Hi all, I have seen lots of answers to the above, but none fit my needs. I need for the user to select a drop down start day i.e. Friday from once cell and then enter the time (24hr format) in the next. I then need them to do the same in the 'Until' day and time cells. The resultant output to be in hours and minutes, taking into account any change in day. I'm fairly ok with excel, but this is doing my noodle in...

See More: How do i return hours and minutes between two days?

Report •

#1
December 21, 2018 at 06:48:43
Do you need to account for Workdays,
IE Monday thru Friday
or just a regular week Monday thru Sunday?

What dates are going to be available from the Drop Down?

What about holidays?

What is going to be the Time range?
IE Regular day of 8:00 AM to 4:00 PM
or is any time going to be acceptable?

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
December 21, 2018 at 07:05:29
I don't see any mention of dates.

Is there a chance the Start day will be a Monday and the Until day will be next week's Tuesday? i.e. 8 days later?

If that situation could ever occur, then Excel would need to know if Monday-Tuesday is 1 day, 8 days, 15 days, etc.

It seems like dates might be required.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Report •

#3
December 21, 2018 at 07:55:50
Pretty sure we're going to have to use some type of Date,
else how do you tell this Friday from next Friday?
Could get very confusing using only Days of the Week.
He's using a Drop Down, so there may be a limit on the number of days
between start & end.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

Related Solutions

#4
December 21, 2018 at 11:01:57
re: "He's using a Drop Down, so there may be a limit on the number of days
between start & end."

We are on the same page in that we need to know that answer. It's very well be possible that nothing that he is tracking lasts for more than say, 72 hours. If that's the case, then we don't need dates.

Assign a number for each day and then just do a little math to determine the number of full days, adjust for the actual hours, yada, yada, yada.

Bottom line (as is very often the case) is that we don't know enough about the requirements/process to answer the question. Once we have all the info, I'll leave it to you since you are the resident MOTRI.

(Master Of Time Related Issues)

;-)


message edited by DerbyDad03


Report •

#5
December 21, 2018 at 11:20:17
Thank you, I like that "Master of Time" moniker, only wish it were true. ;-)

MIKE

http://www.skeptic.com/


Report •

Ask Question