Search:

Type: Posts; User: rstuart19; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Convert SAP data field into Excel Date and Time

    Australia 🇦🇺 Excel 2016
  2. Re: Convert SAP data field into Excel Date and Time

    Sorry Rick i copied straight from yours and pointed to correct cell references and it still comes up with that error - it's obviously me but Fazza's seemed to do the trick without me breaking it so...
  3. Re: Convert SAP data field into Excel Date and Time

    Thanks Fazza - yes that worked with a copy and paste (and point to correct cell ref) it is a much quicker and shorter formula than my effort! Only way to learn is give it a go :-)

    I used it as...
  4. Re: Convert SAP data field into Excel Date and Time

    No its ok - hadn't formatted time difference cell properly - it was HH:MM:SS not [HH]:MM:SS all good it works :-)
  5. Re: Convert SAP data field into Excel Date and Time

    Ignore all that LOL can't subtract the date if I change it - only subtracts the time so won't add 24 hrs to the time of day if i change start day to 1 day earlier. I'll just learn the m-code and...
  6. Re: Convert SAP data field into Excel Date and Time

    It wouldn't let me calculate the difference using your formula :-( came up as name error.

    So I broke it all down individually for each step and came up with this combined formula (probably way too...
  7. Re: Convert SAP data field into Excel Date and Time

    Thanks Rick! Provided my colleague doesn’t need the start and finish for anything else other than working out time difference that’ll be nice and simple 👍🏻
  8. Re: Convert SAP data field into Excel Date and Time

    I do now! I’ll look into it again thanks for assistance.
  9. Re: Convert SAP data field into Excel Date and Time

    Hi thanks for helping. IT was a copy and paste error - I was trying to show same date and year, just 2 hour difference.

    I am not familiar with code - are you able to put into an actual workbook...
  10. Convert SAP data field into Excel Date and Time

    <tbody>
    Need to convert following cell data by either formula or clever format number custom style

    CURRENT DATA IMPORTED


    <tbody>
    START
    FINISH
    hh/mm
Results 1 to 10 of 10