10 Comments

So help me, that why I am asking for help sir!

time-5-4-11.xlsx

time-5-4-11.xlsx

=IF(IF(ISERROR(FIND("m",E1

IF(ISERROR(FIND("m",E11)),

IF(ISERROR(FIND("m",E11)),

Copy to other cells...

Try formula below for E12

=IF(IF(ISERROR(FIND("m",E1

IF(ISERROR(FIND("m",E11)),

IF(ISERROR(FIND("m",E11)),

Copy to other cells...

Sample attached...

test.xlsx

test.xlsx

The total time will then be simple as one less the other. You will have to tweak when working past midnight. Fairly simple logic - if finish less than start then the formula would be "24 hours minus start minus finish" rather than "finish minus start".

Custome format for then adding up the hours "[h]:mm" will go beyond 24 hours whereas other time formats will start again from zero if you go beyond 24

Cheers

Rob H

By clicking you are agreeing to Experts Exchange's Terms of Use.

Title | # Comments | Views | Activity |
---|---|---|---|

VB.net Excel Add-in TaskPane not opening | 3 | 33 | |

Copy Value of cell in formula | 1 | 24 | |

MS Excel Cell questions | 5 | 39 | |

simple formula but cannot get it work. | 5 | 19 |

Join the community of 500,000 technology professionals and ask your questions.

Connect with top rated Experts

**10** Experts available now in Live!