'HOUR function' category


You are here: Excel » Functions » Date and Time » HOUR function »

Count complete hours between two times
The formula in cell D5 calculates the number of complete hours between the time entries in cell B5 and C5. […]
How to use the HOUR function
Returns an integer representing the hour of an Excel time value. The returning number is ranging from 0 (12:00 A.M.) […]
Days between two dates
The DATEDIF function in cell E3 allows you to calculate days between two dates.
How to AVERAGE time
Table of Contents How to AVERAGE time How to enter an array formula Explaining formula How to AVERAGE time hh […]
How to calculate overlapping time ranges
I found an old post that I think is interesting to write about today. Think of two overlapping ranges, it […]

Excel categories

FunctionsFormulasExcel TablesAdvanced FilterData ValidationDrop DownNamed RangesExcel SolverChartsConditonal FormattingPivot TablesVBAMacrosUDFsArchive