Difference between two Date and Times cell in Hours

**kidengineer** · 07-19-2013, 05:24 AM

I've been searching around and most of the issues revolves around either fixed date and time entered into the vba code or suggestion to use some sort of format to extract the time information out.

Attached is a sample work book for working.

What I'd want to eventually achieve is to find the difference in Hours between the first cell (A1) that containts Date & Time and the last cell that contains Date & Time in this case cell A495. The data provided is dynamic - it may be longer or shorter.

The difference in hours would then be copied to another cell say C1.

Thanks in advance for viewing and for your suggested solutions.

Kind Regards

Sample2.xlsx

**Andy Pope** · 07-19-2013, 05:29 AM

Assuming the entries are in order

=MAX(A:A)-MIN(A:A)

with number format of [h]:mm

**Debraj Roy** · 07-19-2013, 05:32 AM

if not in order than you can try this too..

Formula:

Please Login or Register  to view this content.

**Andy Pope** · 07-19-2013, 05:35 AM

@Debraj Roy, if there not in order then you need a formula to replace -A1 to locate the min time.

**kidengineer** · 07-19-2013, 05:40 AM

Originally Posted by Andy Pope

Assuming the entries are in order

=MAX(A:A)-MIN(A:A)

with number format of [h]:mm

This worked well even if the entries are jumbled up

Thanks !

It now shows e.g. 3:59 - Anyway that it could show the number 4 ? I understand that I cannot find the format under 'Customs' and there may not be away around this. Thanks.

**Andy Pope** · 07-19-2013, 05:44 AM

order of entries does not affec the MIN/MAX formula. It's only if you specifically want to calculate the difference between 1st and last entry that you need to actually locate the last entry.

And saying that I know realise my comment to Debraj Roy is completely redundent. My bad!

**Debraj Roy** · 07-19-2013, 05:44 AM

Thanks for the guidance Andy..

Agree.. noted and bowed...

**kidengineer** · 07-23-2013, 04:05 AM

Nevertheless, Thanks for the help guys ! Learning never ends

Difference between two Date and Times cell in Hours

LinkBack

Thread Tools

Rate This Thread

Display

Difference between two Date and Times cell in Hours

Re: Difference between two Date and Times cell in Hours

Re: Difference between two Date and Times cell in Hours

Re: Difference between two Date and Times cell in Hours

Re: Difference between two Date and Times cell in Hours

Re: Difference between two Date and Times cell in Hours

Re: Difference between two Date and Times cell in Hours

Re: Difference between two Date and Times cell in Hours

Thread Information

Users Browsing this Thread

Similar Threads

Required difference between two dates/times in hours

Need difference between two dates/times in hours

Difference between 2 times (24 hours)

Calculating difference in times as hours and minutes

[SOLVED] HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions