Get instant live Excel expert help with Time and Date Functions

I'm trying to produce a pivot table on worksheet H showing the number of records by hour for each room based on the NYC (eastern) time. This will require the provided LogTimeStamp time to be converted to our EST from GMT listed in the table worktable worksheet

Question on how to calculate median, and how to find the minimum and maximum value of a function, from a large data set for different categories

I am tracking inspections for aircraft using the aircraft hours and till due inspections. Example: aircraft hours 400 the inspections are on a 25 hour reoccurring basis. I need a formula for counting down the 25 hour inspection as the aircraft hours increase as the inspection comes due then resets for when the inspection was completed. aircraft hours 400 inspection completed at 380 hours till due 5 hours

I am trying to use excel to simulate the charging and discharging of a battery. As in once the battery reaches 1, the level of charge will decrease until it reaches 0 and then begin charging again back to 1. I have tried using multiple IFS functions that do not seem to be working as, for example:IFS(cell<=1, cell-10%, cell>0, cell+10%), the array will always continue to decrease or increase past 0 and 1 respectively and will never loop within the range. Hypothetically you can say that it increases 10% an hour from 0-1 and decreases 10% an hour from 1-0. Any help much appreciated thanks.

YOU JUST HELPED ME ONE HOUR AGO WITH PPT SLIDE LABELING THAT WAS CREATED FROM AN EXCEL SPREADSHEET AND IT TOOK ONLY A FEW MINUTES. NEED HELP ONE MORE TIME/ PLEASE I HAVE A DEADLINE IN 1 HOUR

I'm trying to analyse a list of times. Column A has start times, Column B has end times. Column D,E,F,G,H,I are columns that calculate how much time has been lost each hour. E.g. A2 = 07:15 B2 = 07.45 D2 = 30:00 I'm having problems figuring out a formula to calculate times in Column B that overlap the times set for Column D,E,F,G,H,I. E.g. A3 = 07:55 B3 = 08.20 D3 should = 05:00 and E3 should = 20:00 Can you help?

I want to add days to date using Workday.intl formula. Before that simply help me to export case name to the merged cell automatically

I want to find the date by adding the number of working hour as well as date using formula Workday or Workday.intl. Can you explain to me the workday definition?

I have a table which lists the schedule of classes for a school. The table is broken down into one hour time slots (columns) and subjects per days of the week (rows). In each time slot per subject is a class number. Each class takes one subject per day. My goal is to say to Excel: "Look in this range and tell me which subjects class X is taking"

Hi, so given check in and check out times of a room in a hospital, I have to find the average room occupancy per hour in a given month.