## calculate day from hh mm

Hello,

I have two given times, well three actually.

C1 local time zone departure (0)
D1 local time zone destination (2)

G1 depart time (15:20) format hh:mm
H1 arrive time (04:08) format hh:mm
I1 arrival day?
J1 journey time (34h 48m) format 'general'

given I know the depart time and journey time, how can I calculate the day of arrival, when depart day is Day 01.
In this scenario, the arrival day equals 3.

I am thinking:
strip down J1 to two numbers, rounded = 34h 48m = 35
(* how to strip LEN from right, left and middle? to get 34.48, rounded up to 35 hours)
work out the time difference = D1-C1 = 2
total journey hours; add the two together = 35+2 = 37
work out hours of first day = 24-G1 = 9
calculate the remaining hours/days = 37 - 9 = 28
how many days is that = 28/24 = 1.16
total days first day hours (=1) + remaining days = 1 + 1.16 = 2.2
answer rounded up = 3 days

Now, how to achieve that in a formula!?

Thanks!

## Anwsers to the Problem calculate day from hh mm

Use this formula, No rounding off needed.
Will take in to account same day also.
=CEILING((G1*1440+(D1-C1)*60+(VALUE(LEFT(J1,FIND("h",J1)-1))*60)+VALUE(MID(J1,FIND(" ",J1)+1,LEN(J1)-FIND(" ",J1)-1)))/1440,1)

I have converted all time in to minutes and then divided it by 1440 for calculating days.
The result is rounded off upper way by ceiling.

## Make Sure that your Computer Meets the System Requirements

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your computer hardware is not up to par, then make sure you upgrade where necessary before continuing:

Microsoft Windows Requirements :

• 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
• 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
• 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

If your computer meets the minimum requirements above, then continue on…

## Recommended Method to Fix the Problem: calculate day from hh mm:

### How to Fix calculate day from hh mm with SmartPCFixer?

1. Download SmartPCFixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The junk files will be shown in the scan result. 2. After the scan is finished, you can see the errors and problems which need to be fixed. 3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair. 