Round Excel Times to Half Hour - Roundup Time BUT Allow 5 Minutes Tolerance

แชร์
ฝัง
  • เผยแพร่เมื่อ 3 ต.ค. 2024

ความคิดเห็น • 8

  • @Up4Excel
    @Up4Excel  3 ปีที่แล้ว +1

    👉 Up4Excel Downloads Library: »» ml.up4excel.com/library
    ✅ FREE Access to ALL Up4Excel Files. Includes Excel Templates, Training Workbooks, Example Data, Cheat Sheets and more. New Content Added Weekly!

  • @sgrphcs1
    @sgrphcs1 ปีที่แล้ว +1

    FYI, you're formula "=ROUNDUP((D2-0.003472)*48,0)/48" rounds on the 5th min so it provides only a 4mins grace period.
    For a 5min grace period use this instead "=ROUNDUP((D2-0.00416)*48,0)/48" That aside I was able to figure it out from your video so THANK YOU!!

    • @Up4Excel
      @Up4Excel  ปีที่แล้ว

      Thank you as so many have watched this and not noticed what you have.... Including me! Sounds like the concept helped you which I'm glad of, and I'm sure your comment will help others too 👍

  • @johnborg5419
    @johnborg5419 3 ปีที่แล้ว +1

    Thanks John. Very Interesting!! : ) : )

    • @Up4Excel
      @Up4Excel  3 ปีที่แล้ว

      Glad to hear it John 👍

  • @wayneedmondson1065
    @wayneedmondson1065 3 ปีที่แล้ว +1

    Thanks John. Great tips! Thanks for the timely lesson (haha!!) Thumbs up!!

    • @Up4Excel
      @Up4Excel  3 ปีที่แล้ว +1

      Any time (haha!)

  • @Up4Excel
    @Up4Excel  3 ปีที่แล้ว +1

    📗 Get Your Video Workbook Template Here: »» cutt.ly/up4v1912G1FD
    🎯 You'll learn how to rounup and charge for time in half hour blocks....but allow for 5 minutes tolerance so you don't look money grabbing by charging people half an hour for a few minutes work.