date and timestamp array

scott2020

New Member
Joined
Feb 27, 2020
Messages
3
Office Version
  1. 2013
Platform
  1. Windows
Hello,
Am trying to find the maxifs and minifs. I need the formula to reference another sheet and two criteria. Currently I am trying to manipulate my formula =MAXIFS(data1!C:C,data1!A:A,Sheet1!F9,data1!E:E,Sheet1!E11),,,,,, F9 is a device name (criteria) E11 is the date with timestamp (criteria) i am trying to reference.
data1 is sheet where data is coming from. Issue at the moment. how to write formula for E11 to work correctly with timestamp with time.
Note,,,, this particular application the date will be the same, its the timestamp differences that i need to figure with.
I have the criterias for the array because the data on data1 sheet has about 9000 dates and timestamps for different devices.
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top