calculate day from hh mm
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!?
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.
Related: How to Download Toshiba Portege R500 HDD/SSD Alert Utility v.220.127.116.11 driver,Way to Update & Download Toshiba Satellite A355-S69403 Motorola Modem Region Select Utility v.18.104.22.168 driver,Where to Download Toshiba Satellite L305-S5926 HW Setup Utility v.2.00.11 driver,[Solved] Download Toshiba Satellite L675-S7115 Laptop Checkup v.22.214.171.124 driver,Method to Download Toshiba Satellite M645-S4080 Media Controller v.126.96.36.199 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: How to Resolve - Boot up Issues- hangs up at the Welcome screen?,Brought back to factory lost Ms one note,Troubleshooting:C:\\PROGRA~2\\MICROS~1\\Windows\\mspdb12.dll is either not designed to run on windows or it contains an error.,[Solved] Built New Computer With Windows 7 - Experiencing Same Data Transfer Issues,Fast Solution to Problem: BSOD almost 2-3 times daily (minidump file available on SkyDrive),All diagnostic tools give 0x800700C1, troubleshooting wizard can't continue,all files try to open with adobe,all icons on desktop have changed to Adobe icon and won't open,All functions of my outlook are working except it will not let me "REPLY" or start a "NEW" email,all f1-f12 shortcuts not work