Shopping

Which hour of the day do you shop most? Read your UPI timestamps

Group your UPI payments by hour of day in a sheet to find your spending peak, with a made-up 100-payment sample, formulas, and what a late peak can suggest.

Editorial illustration for Which hour of the day do you shop most? Read your UPI timestamps

To find your spending peak, copy your UPI payments with their times into a sheet, pull out the hour with the HOUR function, and total the count and rupees for each hour band. In the made-up sample below, the 18 payments made after 9 pm carry about 29 per cent of the rupees, which shows why the time of day is worth checking.

Where do you get the time of each payment?

Your UPI app's payment history usually shows the date and time of each payment. Bank statements may show only the date, so check your own statement before relying on it. Copy the rows into a sheet with three columns: date, time and amount. If the time arrives as text such as 9:42 PM, the formulas below need one small adjustment, shown further down.

How do you extract the hour and group the payments?

Say dates are in column A, times in column B, amounts in column C, and your data runs from row 2 to row 101. In D2 write the hour:

  • =HOUR(B2) when column B holds a real time value.
  • =HOUR(TIMEVALUE(B2)) when column B holds text like 9:42 PM.

Fill D2 down to D101. Now count and total by band using ranges rather than whole columns:

  • Payments from 18:00 to 20:59: =COUNTIFS($D$2:$D$101, ">=18", $D$2:$D$101, "<21")
  • Rupees in the same band: =SUMIFS($C$2:$C$101, $D$2:$D$101, ">=18", $D$2:$D$101, "<21")
  • Late night and early hours: =SUMIFS($C$2:$C$101, $D$2:$D$101, ">=21") + SUMIFS($C$2:$C$101, $D$2:$D$101, "<6")

A pivot table does the same job faster: put the hour in rows and the sum of amount in values. Then insert a column chart so the peak is visible at a glance.

What does a made-up sample look like?

Here are 100 invented payments across a month, grouped into six bands. They are not a typical pattern.

Hour bandPaymentsRupeesAverage per payment
6 am to 10 am142,380170
10 am to 2 pm224,150189
2 pm to 6 pm193,020159
6 pm to 9 pm276,840253
9 pm to midnight155,110341
Midnight to 6 am31,450483

Counts add to 100 and rupees to ₹22,950. Evening (6 to 9 pm) carries ₹6,840, about 30 per cent of the month. The 18 payments after 9 pm total ₹6,560, about 29 per cent of the rupees from only 18 per cent of the payments, and their average of about ₹364 is nearly double the midday average of about ₹189.

What can a late-evening peak suggest?

Not a verdict, just a prompt to look closer. Late payments are often larger because they are dinner orders, online shopping, or bill payments left for the end of the day. Scroll through the rows after 9 pm and sort them: food, shopping, subscriptions, something else? If most are online shopping, that is the hour to apply a wait rule, such as moving items to a wishlist and deciding the next morning.

Split the rows further if you can. Weekday evenings and weekend evenings often behave differently, and so do the days just after payday. Sort the late rows by amount, look at the three largest, and ask whether each was planned. A single large late payment, such as a booking or a bill, can make a whole band look heavy when the other payments in it are small.

What do you do with the finding?

  1. Name the peak band and what is bought in it.
  2. Pick one small friction: log out of shopping apps after 9 pm, or remove saved cards from the app you use late at night.
  3. Compare the next month's band totals with this one.
  4. Move any fixed payments, such as bills, out of the evening so they do not blur the picture.

If a sheet stops being enough and you want the same grouping without copying rows by hand, SpendixAI can import a bank or card statement and its Report builder can filter and group transactions, though you should check whether your own statement carries times at all.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports