Get instant live Excel expert help with Time and Date Functions

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

1. Please calculate “Roomed Census” (see below for definition) for every hour beginning on February 1, 2014 at 1:00 and ending February 28, 2014 at 23:00 (this is 671 values). Now average these values based on hour of day across the entire month. What is the busiest (highest census) and the least busy (lowest census) hour of day for the ER, and what is the average census at those two hours? a. Roomed Census - This is the number of patients who are in rooms at a given point of time - census is a snapshot in time. Patients in rooms can be thought of as those who have been placed in a room but have not left as of that point in time.
Solved by T. C. in 15 mins
I have a timesheet calculator with hours down the side, each cell representing 1/2 hour, days across the top, and project names/ numbers randomly through the body of the table. I need to calculate the time spent on each project automatically. I have 15 guys submitting weekly timesheets on 20-30 projects, so it would be ideal if I could automate the calculation> I have tried pivot tables, but they are not sorting the information how I would like
Solved by O. J. in 21 mins
how to find the average value of a function to calculate the time period to create and shorten table to just each hour
Solved by G. E. in 19 mins
If I modify the date (on g3), the calendar automatically changes to display the availabilty of each person (cells G5:J5). This is depend on the dates of the log (Cells B6:B14), the times (C6:C14), and the names (D6:D14). If one of this values changes, then the calendar does to. However, what I need is that if a person is "Ocupado" (which means busy, btw) at a certain time ((e.g 9:00 AM) obviously because on the log the person is busy at that time, and that date) then he should also be ocupado the next hour (e.g. 9:30 AM)
Solved by F. H. in 12 mins
If I modify the date (on Calendar D3), the calendar automatically changes to display the availabilty of each person (cells e5:H31). This is depend on the dates of the daily log (Daily log column G), the times (Daily log column H), and the names (Daily log column I). If one of this values changes, then the calendar does to. However, what I need is that if a person is "Ocupado" (which means busy, btw) at a certain time ((e.g 9:00 AM) obviously because on the log the person is busy at that time, and that date) then he should also be ocupado the next hour (e.g. 9:30 AM). In a nutshell, the shifts are always going to be an hour long, but they can start at 9:30, too; in which case it should be ocupado for 10:00 too.
Solved by C. L. in 26 mins
I am having an issue with creating a formula where I am able to track when a specific equipment is due for service by Hours rather than by date as some equipment is used more than others in a given time frame. Possibly where I could specify the hour interval a particular piece of equipment requires service.
Solved by V. C. in 17 mins
I have a table of species detections over time, it has multiple species and multiple times (hh:mm:ss). I have another table that I want to use to tally up the first table. For example, how many of Species A were detected during the 12:00 hour. How do I automate the second table to draw its information from the first?
Solved by D. W. in 14 mins
I am trying to calculate our Per Diem rate. they get \$100 a day max @\$10 per hour. I how would I write it so that the days that equal 10 hours =\$100 and anything less than 10 calculates at the hours worked times \$10.
Solved by B. B. in 29 mins
Column G contains Date Time data every 15min. slots calculated from a different file Column I calculated base on G Column J based on I I need to have a new column created, base on column I, that will have no date no time format but just the Hour from column I in a numeric or general format
Solved by B. S. in 22 mins
I want to filter/ copy hourly data automatically from raw data sheet to daily report sheet based on date matching for every hour
Solved by K. H. in 20 mins