Posts by Gerald Young25

Kyle Johnson2 said:Don't take this personally, but please provide an attachment containing dummy data—fake names and all—so we can actually see what we're dealing with... I'd rather not waste my time guessing. 😉

Can I send this via email?

True, that works, but then I’m stuck manually checking which entries are over 10 hours and which are under... necessitating constant formula tweaks.

One more thing:

I have employee work hours formatted as either "3h 46min" or just "46min." Every day, individual daily reports are logged on separate sheets for each specific day. My goal is to aggregate all those hours into one monthly report.

I attempted the most straightforward approach:
The code:

However, the result just shows 0:00:00. It seems I can't get this time format to sum correctly.

Keep in mind these values come from an automated export from a third-party software. I have zero control over how that application formats the exported time strings, and frankly, the current format makes calculations nearly impossible.

Thanks in advance.

Gerald Young25 said:I managed to pull it off using that new example you shared.
Everything is running perfectly now. Thanks for the help...
👍

http://www.microsoft.com/en-us/office/excel200...working-hours.html

Kyle Johnson2, which conversion formula should I use when dealing with time formatted like this:

2d 12h 52min

The formula you provided works fine until we hit the 10-hour mark (xH), but once it exceeds 10, it fails...

Thanks in advance.

Kyle Johnson2 said:I didn't assume you were following the instructions to the letter.
What does the file actually look like? Please provide an example. Is that "2d 2h 15min" result generated via a formula, or is it just static text?
Take another look at this link because I’ve made some adjustments based on your example.

Using this new example you provided, I managed to get it working.
Everything is running perfectly now. Thanks for the help...
👍

Kyle Johnson2 said:Try using a custom format or setting it to Time 37:33:55 (check this LINK)

Tried it. Still nothing...

Greetings, everyone.

I am receiving an export from a specific report into Excel that calculates task duration.

The cell is set to a general format, yielding results such as: 2d 2h 15min.

How might I convert this duration into standard working hours—for instance: 50:15?

Thank you in advance for any assistance...