Hi guys,
Looking for help on 5 things:
1. How do I get to show time as 09:00 AM or 13:00 PM without having to write colon? I just want to write straight 0900 and get it shown as 09:00 AM, same as the PM version.
2. I know how to get duration/elapsed time by formula (example: 09:00 am (A3)- 1:30 pm (B3) is 4 hours 30 minutes "=TEXT(B3-A3,""hh:mm" is only showing elapsed time 04:30). But how do I get the elapsed time to automatically show as 4h30m in cell?
3. How to show time as 13:30 pm? Tried using [h]:mm AM/PM but it's giving me error and doesn't work. hh:mm AM/PM shows 01:30 pm.
4. Also, there is another time in other cell - lets say A5 5:40 pm. Why can't I use this formula (same as question 2 formula) "=TEXT(B3-A5),"hh:mm")?
5. So as you can see, there is formula and when it's empty elapsed/duration time is showing 00:00. How do I get to hide this if there are no time/data?
Need your advice. Thank you in advance.
Bookmarks