ExcelBanter - I need to measure hours between two events(time/date) to give me .

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I need to measure hours between two events(time/date) to give me . (https://www.excelbanter.com/excel-worksheet-functions/25771-i-need-measure-hours-between-two-events-time-date-give-me.html)

iartis

I need to measure hours between two events(time/date) to give me .

Ron Rosenfeld

On Wed, 11 May 2005 15:45:01 -0700, iartis
wrote:

=DateTime2 - DateTime1

Format result as [h], or [h]:mm

--ron

Alok

Hi Iartis

Say A1 has the starting Time/Date and A2 has the ending Time/Date then the
following formula will give you the number of hours A2 occurs after A1

=(A2-A1)*24

Just remember to format as General the cell in which you enter this formula.
Alok Joshi

"iartis" wrote:

All times are GMT +1. The time now is 06:18 AM.