Jun 06 2022 07:26 AM
Anyone know how to set up a Begin & End time using the Actual Hours added to the date to get the End date and time in Excel? Per the Example- Formulas and Functions
Actual Hrs | Begin | End |
4.88 | 6/30/2022 | 7/1/2022 |
2.01 | ||
5.92 | ||
7.22 | ||
3.91 | ||
12.69 | ||
2.23 | ||
9.25 | ||
2.23 |
Is this a possibility in Excel?
Jun 06 2022 07:52 AM
Jun 06 2022 08:13 AM
Jun 06 2022 08:22 AM
Jun 06 2022 08:27 AM
Make sure that you format columns I and J as date AND time, for example using the custom number format m/d/yyyy h:mm AM/PM
Jun 06 2022 08:34 AM
Jun 06 2022 08:44 AM
It's hard to visualize what you mean. Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
Jun 06 2022 09:33 AM
Jun 06 2022 09:56 AM
If this option
when you reply on post is not available for you, share on any resource as @Hans Vogelaar suggested and share the link. Be sure access is granted.
Jun 06 2022 09:59 AM
Jun 06 2022 02:54 PM - edited Jun 06 2022 02:54 PM
I have received your workbook in your PM.
This is what I see in columns G to I:
What exactly do you want to do?
Jun 07 2022 06:43 AM
Jun 07 2022 07:54 AM
Your sample workbook has several rows starting on weekend days and on public holidays. What's up with that?
Jun 07 2022 08:01 AM
Jun 07 2022 01:37 PM
See the attached version. It is now a macro-enabled workbook, so you'll have to allow macros.
Jun 09 2022 08:20 AM
Jun 09 2022 10:10 AM
Jun 06 2022 08:07 AM
Solution