Hey there! Let's break down the problem you're facing: trying to subtract two time strings directly (like heureCommande - "18:50") won't work in JavaScript because strings can't be subtracted like numerical values—this will just give you NaN (Not a Number). Plus, your original code has a syntax error with 18:50 (it needs to be wrapped in quotes as a string).

The right approach is to convert both time values into a common measurable unit (like total minutes since midnight) so we can perform actual arithmetic on them. Here's a step-by-step solution:

1. Create a Helper Function to Convert Time Strings to Minutes #

First, let's make a reusable function that takes a HH:MM time string and converts it into the total number of minutes since midnight. This makes math straightforward.

// Convert "HH:MM" time string to total minutes since midnight
function timeToMinutes(timeStr) {
  const [hours, minutes] = timeStr.split(':').map(Number);
  return hours * 60 + minutes;
}

2. Optimize Your Current Time Handling #

Your original code to format the current time works, but we can simplify it and also get the total minutes for calculation at the same time:

// Get current date object
const currentTime = new Date();

// Calculate total minutes for current time
const currentTotalMinutes = currentTime.getHours() * 60 + currentTime.getMinutes();

// Format current time to "HH:MM" string (cleaner approach)
const heureCommande = `${String(currentTime.getHours()).padStart(2, '0')}:${String(currentTime.getMinutes()).padStart(2, '0')}`;

3. Calculate the Time Interval #

Now, let's take the time from your database (e.g., "11:50"), convert it to minutes, and compute the difference with the current time's total minutes:

// Example time retrieved from database
const dbTimeStr = "11:50";
const dbTotalMinutes = timeToMinutes(dbTimeStr);

// Calculate the difference in minutes
const timeDifference = currentTotalMinutes - dbTotalMinutes;

// Output results
console.log(`Current time: ${heureCommande}`);
console.log(`Database time: ${dbTimeStr}`);
console.log(`Time interval: ${timeDifference} minutes`);

// Optional: Convert difference to hours and minutes for readability
const hours = Math.floor(Math.abs(timeDifference) / 60);
const minutes = Math.abs(timeDifference) % 60;
console.log(`Formatted interval: ${hours}h ${minutes}m`);

Key Notes #

• A positive timeDifference means the current time is later than the database time; a negative value means the database time is later.
• The padStart(2, '0') method ensures we always get two-digit hours and minutes (e.g., 09:05 instead of 9:5), matching your original formatting goal.
• Avoid direct arithmetic on time strings—always convert to numerical units first!

内容的提问来源于stack exchange，提问作者tony