Dear All
Dear All
would you please se what the problem in cell
B7 with the following formula
because it give next day although the time in the same dayHTML Code:
Dear All
Dear All
would you please se what the problem in cell
B7 with the following formula
because it give next day although the time in the same dayHTML Code:
Why not use this?
=B2+TIME(TRUNC(B4/100),MOD(B4,100),0)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
B C 2 01-Jun-2017 3 16:00 4 18:00 5 6 01-Jun-17 16:00B6: =B$2 + DOLLARDE(B3/100, 60)/24 7 01-Jun-17 18:00
Entia non sunt multiplicanda sine necessitate
Formulas in B6 and B7 are way overcomplicated.
Try
B6: =B$2+TEXT(B3,"00\:00")
Fill down to B7
if you change the value in B4 to 0100 its must be change the date to 2-7-2017 but with he formula its
Try
B6: =B$2+TEXT(B3,"00\:00")
B7: =B$2+TEXT(B4,"00\:00")+(B3>B4)
Dear Jonmo1 your last formula working good
many thank for all help me
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks