Get instant live Excel expert help with Time and Date Functions

An hour ago i requested for a macro to fix the date and time issue of my chart so that the current date and time would show up whenever i entered something into column b the expert was nice but after a while of using it seems to have stopped working but every time i re download the macro-version of my chart it works i just want a checkup and hopefully a fix. (PS, just noticed this cannot take macro enabled excel files so i had to switch it to normal hopefully that's not a problem)

Based on the data I provide, we need to first group the hour in chunks of 36 hours. and then create a heat map. Can you help me?

Hello! I need to create a labour hour tracker spreadsheet for our 24-some employees that tracks their weekly, monthly, and yearly totals (this includes categories such as straight time, OT, sick days, etc). The problem is that my boss wants something where if I need to add an employee, I don't need to go back in and change all the formulas. I would appreciate any help!

Good morning! I am trying to create a labour hour tracker which will tally daily, monthly and yearly totals for our employees. However my boss wants to be able to add employees throughout the year without having to go in and alter the formulas by hand. Is this even possible?

I want to find out how many hours people worked. I need them to be rounded to the nearest quarter of hour (ex. 2:07=2:00 and 2:08=2:15). It works out beautifully for first shift, but second shift sometimes jumps on to the next day (12:00 am, 1:00 am of the next day). I keep getting the wrong count.

Edit cell D18 to indicate that we ship TODAY (mm/dd format) if the order is entered before noon; otherwise we ship tomorrow (mm/dd format). Use the IF, HOUR, and NOW, and TODAY functions.

was working with an expert about an hour ago who had come up with the right formula but I can't find that file. How do I bring it back. It was for a compound interest payment

can some one can create a graph using the data in A and B column , the sample graph i have pasted, u can delete it, it should be in the same formate, as 1 or 2 hour gap, with one date.

In order to adjust an incorrect time stamp on a photo, I would like to subtract an amount of time (9 hours) from the current incorrect time stamp of (4 am). However, since subtracting 9 hours from 4 am (would normally give you 7 pm the previous day or 19:00 pm) give you negative time, excel is not recognizing that this subtraction occurs on a 24 hour clock and cannot compute the formula: the resulting output is: #######.... As long as I subtract 9 hours from a time that is greater than 9:00 am, excel is able to compute. Please can you help me resolve this issue.

I want to learn how to make dependent drop down list for multiple cells in google spreadsheets, I repeat multiple cells. I can make for single cell. Is it too hard to understand? A 10 year old would agree it is as clear as daylight. Yet who assisted me last time sent me an excel file despite I repeatedly told him I know how it works on excel, I want to learn for google sheets. He won't close the session either, I had to wait 1 hour to post again.