
Build a time from hour, minute, second
14 + 30 + 15 → 2:30:15 PM
147 free Excel templates to turn text into clock times and write them the way a letter needs. For example, 0905 becomes 9:05 AM. Pick the one that matches your list, download it and paste your data in. No sign-up, no macros.
147 templates

14 + 30 + 15 → 2:30:15 PM

14:30:15 as text → 2:30:15 PM

November 4, 2026 2:30:15 PM → 2:30:15 PM

2:30:15 PM → 14

2:30:15 PM → 30

2:30:15 PM → 15

11/4/2026 + 2:30:15 PM → 11/4/2026 2:30:15 PM

2:30:15 PM → 2

2 + 30 + p.m. → 2:30 PM

11/4/2026 2:30:15 PM + 9:05:00 AM → 11/5/2026 9:05:00 AM

4-Nov-2026 + 2:30:15 PM → November 4, 2026 2:30:15 PM

0905 → 9:05 AM

143015 → 2:30:15 PM

14:30 → 2:30 PM, 00:00 → 12:00 AM, blank stays blank

2:30:15 PM → 14:30:15

2:30 PM → 14:30

Duration 49:30 → text 49:30, not 1:30

49:30:15 → text 49:30:15, not 1:30:15

A negative 90-minute difference → -1:30

49.5 hours → 49:30

49:30 → 49.5 hours

2970 minutes → 49:30

49:30 → 2970 minutes

178215 seconds → 49:30:15

49:30:15 → 178215 seconds

49 hours and 30 minutes → 49:30

11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM → 49.5 hours

11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM → 2970 minutes

11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM → 178200 seconds

11:30 PM to 7:15 AM → 7:45

49:30 → 49 whole hours

2:30–5:30 PM and 4:30–7:30 PM → 1:00 shared

2:30:15 PM to 4:00:15 PM → 1:30:00; reversed → Review order

11:30 PM plus 90 minutes → 1:00 AM

12/31/2026 11:30:00 PM + 90 minutes → 1/1/2027 1:00:00 AM

11/4/2026 2:30:15 PM + 10 hours → 11/5/2026 12:30:15 AM

12/31/2026 11:30:00 PM + 1800 seconds → 1/1/2027 12:00:00 AM

7/4/2026 11:59:59.6 PM → 7/5/2026 12:00:00 AM

7/4/2026 11:59:59 PM → 7/5/2026 12:00:00 AM

1/1/2027 7:15:30 AM, 10 minutes → 1/1/2027 7:20:00 AM

7/4/2026 11:59:59 PM up to 15 minutes → 7/5/2026 12:00:00 AM

1/1/2027 7:15:30 AM, 10 minutes → 1/1/2027 7:10:00 AM

2026-11-04T14:30:15 → November 4, 2026 2:30:15 PM

2026-11-04T14:30:15.123 → 11/4/2026 2:30:15.123 PM

T14:30:15 → 2:30:15 PM

26-11-04 14:30:15 + 2000 → November 4, 2026 2:30:15 PM

11/04/26 2:30:15 PM + 2000 → November 4, 2026 2:30:15 PM

04-NOV-2026 14.30.15 → November 4, 2026 2:30:15 PM

04-NOV-2026 02.30.15.123456789 PM → 11/4/2026 2:30:15.123 PM

04-NOV-2026 14.30.15.123456 → 11/4/2026 2:30:15.123 PM

Wed Nov 04 14:30:15 2026 → November 4, 2026 2:30:15 PM

20261104143015 → November 4, 2026 2:30:15 PM

20261104 143015 → November 4, 2026 2:30:15 PM

4-Nov-2026 | 14:30:15 → November 4, 2026 2:30:15 PM

Unix seconds 1793802615 → November 4, 2026 2:30:15 PM

Unix milliseconds 1793802615000 → November 4, 2026 2:30:15 PM

/Date(1793802615000)/ → November 4, 2026 2:30:15 PM

Seconds since 1960 2109421815 → November 4, 2026 2:30:15 PM

04-NOV-26 02.30.15.123456 PM + 20 → 11/4/2026 14:30:15.123

NULL → blank; 2026-11-04T14:30:15 → November 4, 2026 2:30:15 PM

2026-11-04T14:30:15+05:30 → November 4, 2026 9:00:15 AM

2026-11-04T14:30:15.123-10:00 → 11/5/2026 12:30:15.123 AM

11/4/2026 2:30:15 PM, offset 5.5 → 11/4/2026 9:00:15 AM UTC

11/4/2026 2:30:15 PM, 5.5 to -6 → 11/4/2026 3:00:15 AM

-03:30 → -210 minutes

14:30:15+05:30 → 09:00:15 UTC clock

2026-11-04 14:30:15 UTC, label UTC → November 4, 2026 2:30:15 PM

November 4, 2026 2:30:15 PM → 2026-11-04T14:30:15

November 4, 2026 2:30:15 PM → 2026-11-04T14:30:15Z

11/4/2026 2:30:15.123 PM → 2026-11-04T14:30:15.123

11/4/2026 2:30:15 PM, -05:00 → 2026-11-04T14:30:15-05:00

11/4/2026 14:30:15.123, -05:00 → 2026-11-04T14:30:15.123-05:00

2:30:15 PM → T14:30:15

November 4, 2026 2:30:15 PM → Unix seconds 1793802615

November 4, 2026 2:30:15 PM → Unix milliseconds 1793802615000

11/4/2026 2:30 PM → November 4, 2026 at 2:30 PM

11/4/2026 2:30 PM → Nov 4, 2026 2:30 PM UTC

November 4, 2026 2:30:15 PM → 20261104_143015

2:30:15[nonbreaking space]PM → 2:30:15 PM

14.30.15 → 2:30:15 PM

2:30:15(PM) → 2:30:15 PM

14h30m → 2:30 PM

49:30 as text → 49:30, not 1:30

49:30:15 as text → 49:30:15, not 1:30:15

2970:15 (minutes:seconds) as text → 49:30:15

PT49H30M15S → 49:30:15

2 01:30:15 → a 49:30:15 duration

49h 30m → an elapsed duration over two days

49,5 hours → 49:30 elapsed

11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM, 0:30 break → 49:00

36:10 in 15-minute blocks → 145 blocks

49:30 in 60-minute blocks → 30 minutes left

49:30 → 2d 1h 30m

49:30:15 → 2970m 15s

49:30:15 → PT49H30M15S

49:30:15 → 2970:15

49.30 (hours.minutes) → 49:30

-0:30 → a negative 30-minute numeric duration

Noon → 12:00 PM; midnight → 12:00 AM

November 4, 2026 + 24:00 → November 5, 2026 12:00 AM

143015 → 2:30:15 PM and 2330 → 11:30:00 PM

14:30, pattern hh:mm → 2:30:00 PM

2026-11-04T14:30:15 → November 4, 2026 2:30:15 PM, or Review timestamp

2026-11-04T14:30:15.123 → 11/4/2026 2:30:15.123 PM, but .12 → Review timestamp

Text 9:05 AM → 9:05:00 AM; timestamps keep their time

2026-11-04T14:30:15 → November 4, 2026 2:30:15 PM; real timestamps stay

2:30:15 PM with hh:mm:ss → 14:30:15

12:00:00 AM, pattern hhmmss → 000000, not 0

0001-01-01T00:00:00 → blank; 2026-11-04T14:30:15 → 11/4/2026 14:30:15

2:30:15 PM, +05:30 → T14:30:15+05:30

11/4/2026 2:30:15 PM, -00 and 30 → 11/4/2026 2:00:15 PM

11/4/2026 + 2:30:15 PM, offset -10 → 11/5/2026 12:30:15 AM UTC

11/4/2026 2:30:15 PM to 11/6/2026 4:00:15 PM → 49:30:00

11/4/2026 14:30 to 11/6/2026 16:00, at 11/5/2026 15:15 → 50%

P2DT1H30M15S → 49:30:15

-2.01:30:15 → -2.062674 days

134382762150000000 → November 4, 2026 2:30:15 PM

639293994150000000 → November 4, 2026 2:30:15 PM

Milliseconds since 1960 2109421815000 → November 4, 2026 2:30:15 PM

Seconds since 1582 14013181815 → November 4, 2026 2:30:15 PM

4002791415, era 0, 2147483648 → 11/4/2026 14:30:15.500

Unix microseconds 1793802615123456 → 11/4/2026 2:30:15.123 PM

493015 → 49:30:15, not 1:30:15

-2.01:30:15.5000000 → -2.062679 days

Wed, 04-Nov-2026 14:30:15 GMT → November 4, 2026 2:30:15 PM

20261104143015+0530 → November 4, 2026 9:00:15 AM

11/4/2026 2:30:15 PM, UTC → 2026-11-04T14:30:15Z

2 + 30 + 15 + PM → 2:30:15 PM

Same-day start and end → Nov 4, 2026 2:30 PM–3:15 PM

11/4/2026 2:30:15 PM + 2:30:15 PM → 11/5/2026 2:30:15 PM

20261104143015.123456+330 → 11/4/2026 9:00:15.123 AM

00000002013015.123456:000 → 49:30:15, not a date

20261104143015.0Z → November 4, 2026 2:30:15 PM

261104143015Z → November 4, 2026 2:30:15 PM

Unix microseconds -1361957384876544 → 11/4/1926 2:30:15.123 PM

1793802615 s, 500000000 ns → 11/4/2026 14:30:15.500

178215 s, 500000000 ns → 2.062679 days

20261104 + 143015 → November 4, 2026 2:30:15 PM

-00 00:30:00.000000 → -0.020833 days

+02-03 → 27 months

{ts '2026-11-04 14:30:15'} → November 4, 2026 2:30:15 PM

/Date(1793802615000+0100)/ → November 4, 2026 2:30:15 PM

Wed Nov 04 2026 14:30:15 GMT-0500 (EST) → 11/4/2026 19:30:15

Wed, 04-Nov-2026 14:30:15 +0530 → November 4, 2026 9:00:15 AM

90 Minutes → 0.062500 days

2:30:15 PM to 5:10:00 PM in 15-minute blocks → 9

-, 49, 30 and 15 → -2.062674 days