'TIME function' category
How to use the TIME function
The TIME function returns a decimal value between 0 (zero) representing 12:00:00 AM and 0.99988426 representing 11:59:59 P.M. Formula in cell […]
The TIME function returns a decimal value between 0 (zero) representing 12:00:00 AM and 0.99988426 representing 11:59:59 P.M. Formula in cell […]
How to AVERAGE time
Table of Contents How to AVERAGE time How to enter an array formula Explaining formula How to AVERAGE time hh […]
Table of Contents How to AVERAGE time How to enter an array formula Explaining formula How to AVERAGE time hh […]
Time sheet for work
I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for […]
I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for […]
Calculate time between time zones
This article demonstrates how to build a time zone chart and calculate times different than your time zone. The worksheet […]
This article demonstrates how to build a time zone chart and calculate times different than your time zone. The worksheet […]
Count entries based on date and time
Question: My issue is that I get the date in this format: 7/23/2011 7:00:00 AM I am trying to count […]
Question: My issue is that I get the date in this format: 7/23/2011 7:00:00 AM I am trying to count […]
Find empty hours in a weekly schedule
The image above demonstartes an array formula in cell B34 that extracts empty hours in a weekly calendar. I have created […]
The image above demonstartes an array formula in cell B34 that extracts empty hours in a weekly calendar. I have created […]
Highlight specific time ranges in a weekly schedule
In a previous post I created a simple weekly schedule with dynamic dates, in this post I am going to […]
In a previous post I created a simple weekly schedule with dynamic dates, in this post I am going to […]
Excel formula categories
AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values