Truncated display of hour in R

Question

I would like to create a vector of characters that will display all the possible Hours/Minutes of the day.

Hence, I would like to create a vector that looks like this

hours_mins = c("0:00",  "0:01",....,"5:09",  "5:10",  "5:11",  "5:12",  "5:14",  "5:15",..., "23:58", "23:59" )

However, my problem in creating this vector is that the hour displayed in hours_mins is not in the regular format, i.e. 00:00, or 05:09. Hence, how do I create a vector such as hours_mins with truncated display of the hour?

user_12500315 · Answer

You can do:

paste(rep(0:23, each = 60), rep(sprintf("%02d", 0:59), 24), sep = ":")

#>    [1] "0:00"  "0:01"  "0:02"  "0:03"  "0:04"  "0:05"  "0:06"  "0:07"  "0:08" 
#>   [10] "0:09"  "0:10"  "0:11"  "0:12"  "0:13"  "0:14"  "0:15"  "0:16"  "0:17" 
#>   [19] "0:18"  "0:19"  "0:20"  "0:21"  "0:22"  "0:23"  "0:24"  "0:25"  "0:26" 
#>   [28] "0:27"  "0:28"  "0:29"  "0:30"  "0:31"  "0:32"  "0:33"  "0:34"  "0:35" 
#>   [37] "0:36"  "0:37"  "0:38"  "0:39"  "0:40"  "0:41"  "0:42"  "0:43"  "0:44" 
#>   [46] "0:45"  "0:46"  "0:47"  "0:48"  "0:49"  "0:50"  "0:51"  "0:52"  "0:53" 
#>   [55] "0:54"  "0:55"  "0:56"  "0:57"  "0:58"  "0:59"  "1:00"  "1:01"  "1:02" 
#>   [64] "1:03"  "1:04"  "1:05"  "1:06"  "1:07"  "1:08"  "1:09"  "1:10"  "1:11" 
#>   [73] "1:12"  "1:13"  "1:14"  "1:15"  "1:16"  "1:17"  "1:18"  "1:19"  "1:20" 
#>   [82] "1:21"  "1:22"  "1:23"  "1:24"  "1:25"  "1:26"  "1:27"  "1:28"  "1:29" 
#>   [91] "1:30"  "1:31"  "1:32"  "1:33"  "1:34"  "1:35"  "1:36"  "1:37"  "1:38" 
#>  [100] "1:39"  "1:40"  "1:41"  "1:42"  "1:43"  "1:44"  "1:45"  "1:46"  "1:47" 
#>  [109] "1:48"  "1:49"  "1:50"  "1:51"  "1:52"  "1:53"  "1:54"  "1:55"  "1:56" 
#>  [118] "1:57"  "1:58"  "1:59"  "2:00"  "2:01"  "2:02"  "2:03"  "2:04"  "2:05" 
#>  [127] "2:06"  "2:07"  "2:08"  "2:09"  "2:10"  "2:11"  "2:12"  "2:13"  "2:14" 
#>  [136] "2:15"  "2:16"  "2:17"  "2:18"  "2:19"  "2:20"  "2:21"  "2:22"  "2:23" 
#>  [145] "2:24"  "2:25"  "2:26"  "2:27"  "2:28"  "2:29"  "2:30"  "2:31"  "2:32" 
#>  [154] "2:33"  "2:34"  "2:35"  "2:36"  "2:37"  "2:38"  "2:39"  "2:40"  "2:41" 
#>  [163] "2:42"  "2:43"  "2:44"  "2:45"  "2:46"  "2:47"  "2:48"  "2:49"  "2:50" 
#>  [172] "2:51"  "2:52"  "2:53"  "2:54"  "2:55"  "2:56"  "2:57"  "2:58"  "2:59" 
#>  [181] "3:00"  "3:01"  "3:02"  "3:03"  "3:04"  "3:05"  "3:06"  "3:07"  "3:08" 
#>  [190] "3:09"  "3:10"  "3:11"  "3:12"  "3:13"  "3:14"  "3:15"  "3:16"  "3:17" 
#>  [199] "3:18"  "3:19"  "3:20"  "3:21"  "3:22"  "3:23"  "3:24"  "3:25"  "3:26" 
#>  [208] "3:27"  "3:28"  "3:29"  "3:30"  "3:31"  "3:32"  "3:33"  "3:34"  "3:35" 
#>  [217] "3:36"  "3:37"  "3:38"  "3:39"  "3:40"  "3:41"  "3:42"  "3:43"  "3:44" 
#>  [226] "3:45"  "3:46"  "3:47"  "3:48"  "3:49"  "3:50"  "3:51"  "3:52"  "3:53" 
#>  [235] "3:54"  "3:55"  "3:56"  "3:57"  "3:58"  "3:59"  "4:00"  "4:01"  "4:02" 
#>  [244] "4:03"  "4:04"  "4:05"  "4:06"  "4:07"  "4:08"  "4:09"  "4:10"  "4:11" 
#>  [253] "4:12"  "4:13"  "4:14"  "4:15"  "4:16"  "4:17"  "4:18"  "4:19"  "4:20" 
#>  [262] "4:21"  "4:22"  "4:23"  "4:24"  "4:25"  "4:26"  "4:27"  "4:28"  "4:29" 
#>  [271] "4:30"  "4:31"  "4:32"  "4:33"  "4:34"  "4:35"  "4:36"  "4:37"  "4:38" 
#>  [280] "4:39"  "4:40"  "4:41"  "4:42"  "4:43"  "4:44"  "4:45"  "4:46"  "4:47" 
#>  [289] "4:48"  "4:49"  "4:50"  "4:51"  "4:52"  "4:53"  "4:54"  "4:55"  "4:56" 
#>  [298] "4:57"  "4:58"  "4:59"  "5:00"  "5:01"  "5:02"  "5:03"  "5:04"  "5:05" 
#>  [307] "5:06"  "5:07"  "5:08"  "5:09"  "5:10"  "5:11"  "5:12"  "5:13"  "5:14" 
#>  [316] "5:15"  "5:16"  "5:17"  "5:18"  "5:19"  "5:20"  "5:21"  "5:22"  "5:23" 
#>  [325] "5:24"  "5:25"  "5:26"  "5:27"  "5:28"  "5:29"  "5:30"  "5:31"  "5:32" 
#>  [334] "5:33"  "5:34"  "5:35"  "5:36"  "5:37"  "5:38"  "5:39"  "5:40"  "5:41" 
#>  [343] "5:42"  "5:43"  "5:44"  "5:45"  "5:46"  "5:47"  "5:48"  "5:49"  "5:50" 
#>  [352] "5:51"  "5:52"  "5:53"  "5:54"  "5:55"  "5:56"  "5:57"  "5:58"  "5:59" 
#>  [361] "6:00"  "6:01"  "6:02"  "6:03"  "6:04"  "6:05"  "6:06"  "6:07"  "6:08" 
#>  [370] "6:09"  "6:10"  "6:11"  "6:12"  "6:13"  "6:14"  "6:15"  "6:16"  "6:17" 
#>  [379] "6:18"  "6:19"  "6:20"  "6:21"  "6:22"  "6:23"  "6:24"  "6:25"  "6:26" 
#>  [388] "6:27"  "6:28"  "6:29"  "6:30"  "6:31"  "6:32"  "6:33"  "6:34"  "6:35" 
#>  [397] "6:36"  "6:37"  "6:38"  "6:39"  "6:40"  "6:41"  "6:42"  "6:43"  "6:44" 
#>  [406] "6:45"  "6:46"  "6:47"  "6:48"  "6:49"  "6:50"  "6:51"  "6:52"  "6:53" 
#>  [415] "6:54"  "6:55"  "6:56"  "6:57"  "6:58"  "6:59"  "7:00"  "7:01"  "7:02" 
#>  [424] "7:03"  "7:04"  "7:05"  "7:06"  "7:07"  "7:08"  "7:09"  "7:10"  "7:11" 
#>  [433] "7:12"  "7:13"  "7:14"  "7:15"  "7:16"  "7:17"  "7:18"  "7:19"  "7:20" 
#>  [442] "7:21"  "7:22"  "7:23"  "7:24"  "7:25"  "7:26"  "7:27"  "7:28"  "7:29" 
#>  [451] "7:30"  "7:31"  "7:32"  "7:33"  "7:34"  "7:35"  "7:36"  "7:37"  "7:38" 
#>  [460] "7:39"  "7:40"  "7:41"  "7:42"  "7:43"  "7:44"  "7:45"  "7:46"  "7:47" 
#>  [469] "7:48"  "7:49"  "7:50"  "7:51"  "7:52"  "7:53"  "7:54"  "7:55"  "7:56" 
#>  [478] "7:57"  "7:58"  "7:59"  "8:00"  "8:01"  "8:02"  "8:03"  "8:04"  "8:05" 
#>  [487] "8:06"  "8:07"  "8:08"  "8:09"  "8:10"  "8:11"  "8:12"  "8:13"  "8:14" 
#>  [496] "8:15"  "8:16"  "8:17"  "8:18"  "8:19"  "8:20"  "8:21"  "8:22"  "8:23" 
#>  [505] "8:24"  "8:25"  "8:26"  "8:27"  "8:28"  "8:29"  "8:30"  "8:31"  "8:32" 
#>  [514] "8:33"  "8:34"  "8:35"  "8:36"  "8:37"  "8:38"  "8:39"  "8:40"  "8:41" 
#>  [523] "8:42"  "8:43"  "8:44"  "8:45"  "8:46"  "8:47"  "8:48"  "8:49"  "8:50" 
#>  [532] "8:51"  "8:52"  "8:53"  "8:54"  "8:55"  "8:56"  "8:57"  "8:58"  "8:59" 
#>  [541] "9:00"  "9:01"  "9:02"  "9:03"  "9:04"  "9:05"  "9:06"  "9:07"  "9:08" 
#>  [550] "9:09"  "9:10"  "9:11"  "9:12"  "9:13"  "9:14"  "9:15"  "9:16"  "9:17" 
#>  [559] "9:18"  "9:19"  "9:20"  "9:21"  "9:22"  "9:23"  "9:24"  "9:25"  "9:26" 
#>  [568] "9:27"  "9:28"  "9:29"  "9:30"  "9:31"  "9:32"  "9:33"  "9:34"  "9:35" 
#>  [577] "9:36"  "9:37"  "9:38"  "9:39"  "9:40"  "9:41"  "9:42"  "9:43"  "9:44" 
#>  [586] "9:45"  "9:46"  "9:47"  "9:48"  "9:49"  "9:50"  "9:51"  "9:52"  "9:53" 
#>  [595] "9:54"  "9:55"  "9:56"  "9:57"  "9:58"  "9:59"  "10:00" "10:01" "10:02"
#>  [604] "10:03" "10:04" "10:05" "10:06" "10:07" "10:08" "10:09" "10:10" "10:11"
#>  [613] "10:12" "10:13" "10:14" "10:15" "10:16" "10:17" "10:18" "10:19" "10:20"
#>  [622] "10:21" "10:22" "10:23" "10:24" "10:25" "10:26" "10:27" "10:28" "10:29"
#>  [631] "10:30" "10:31" "10:32" "10:33" "10:34" "10:35" "10:36" "10:37" "10:38"
#>  [640] "10:39" "10:40" "10:41" "10:42" "10:43" "10:44" "10:45" "10:46" "10:47"
#>  [649] "10:48" "10:49" "10:50" "10:51" "10:52" "10:53" "10:54" "10:55" "10:56"
#>  [658] "10:57" "10:58" "10:59" "11:00" "11:01" "11:02" "11:03" "11:04" "11:05"
#>  [667] "11:06" "11:07" "11:08" "11:09" "11:10" "11:11" "11:12" "11:13" "11:14"
#>  [676] "11:15" "11:16" "11:17" "11:18" "11:19" "11:20" "11:21" "11:22" "11:23"
#>  [685] "11:24" "11:25" "11:26" "11:27" "11:28" "11:29" "11:30" "11:31" "11:32"
#>  [694] "11:33" "11:34" "11:35" "11:36" "11:37" "11:38" "11:39" "11:40" "11:41"
#>  [703] "11:42" "11:43" "11:44" "11:45" "11:46" "11:47" "11:48" "11:49" "11:50"
#>  [712] "11:51" "11:52" "11:53" "11:54" "11:55" "11:56" "11:57" "11:58" "11:59"
#>  [721] "12:00" "12:01" "12:02" "12:03" "12:04" "12:05" "12:06" "12:07" "12:08"
#>  [730] "12:09" "12:10" "12:11" "12:12" "12:13" "12:14" "12:15" "12:16" "12:17"
#>  [739] "12:18" "12:19" "12:20" "12:21" "12:22" "12:23" "12:24" "12:25" "12:26"
#>  [748] "12:27" "12:28" "12:29" "12:30" "12:31" "12:32" "12:33" "12:34" "12:35"
#>  [757] "12:36" "12:37" "12:38" "12:39" "12:40" "12:41" "12:42" "12:43" "12:44"
#>  [766] "12:45" "12:46" "12:47" "12:48" "12:49" "12:50" "12:51" "12:52" "12:53"
#>  [775] "12:54" "12:55" "12:56" "12:57" "12:58" "12:59" "13:00" "13:01" "13:02"
#>  [784] "13:03" "13:04" "13:05" "13:06" "13:07" "13:08" "13:09" "13:10" "13:11"
#>  [793] "13:12" "13:13" "13:14" "13:15" "13:16" "13:17" "13:18" "13:19" "13:20"
#>  [802] "13:21" "13:22" "13:23" "13:24" "13:25" "13:26" "13:27" "13:28" "13:29"
#>  [811] "13:30" "13:31" "13:32" "13:33" "13:34" "13:35" "13:36" "13:37" "13:38"
#>  [820] "13:39" "13:40" "13:41" "13:42" "13:43" "13:44" "13:45" "13:46" "13:47"
#>  [829] "13:48" "13:49" "13:50" "13:51" "13:52" "13:53" "13:54" "13:55" "13:56"
#>  [838] "13:57" "13:58" "13:59" "14:00" "14:01" "14:02" "14:03" "14:04" "14:05"
#>  [847] "14:06" "14:07" "14:08" "14:09" "14:10" "14:11" "14:12" "14:13" "14:14"
#>  [856] "14:15" "14:16" "14:17" "14:18" "14:19" "14:20" "14:21" "14:22" "14:23"
#>  [865] "14:24" "14:25" "14:26" "14:27" "14:28" "14:29" "14:30" "14:31" "14:32"
#>  [874] "14:33" "14:34" "14:35" "14:36" "14:37" "14:38" "14:39" "14:40" "14:41"
#>  [883] "14:42" "14:43" "14:44" "14:45" "14:46" "14:47" "14:48" "14:49" "14:50"
#>  [892] "14:51" "14:52" "14:53" "14:54" "14:55" "14:56" "14:57" "14:58" "14:59"
#>  [901] "15:00" "15:01" "15:02" "15:03" "15:04" "15:05" "15:06" "15:07" "15:08"
#>  [910] "15:09" "15:10" "15:11" "15:12" "15:13" "15:14" "15:15" "15:16" "15:17"
#>  [919] "15:18" "15:19" "15:20" "15:21" "15:22" "15:23" "15:24" "15:25" "15:26"
#>  [928] "15:27" "15:28" "15:29" "15:30" "15:31" "15:32" "15:33" "15:34" "15:35"
#>  [937] "15:36" "15:37" "15:38" "15:39" "15:40" "15:41" "15:42" "15:43" "15:44"
#>  [946] "15:45" "15:46" "15:47" "15:48" "15:49" "15:50" "15:51" "15:52" "15:53"
#>  [955] "15:54" "15:55" "15:56" "15:57" "15:58" "15:59" "16:00" "16:01" "16:02"
#>  [964] "16:03" "16:04" "16:05" "16:06" "16:07" "16:08" "16:09" "16:10" "16:11"
#>  [973] "16:12" "16:13" "16:14" "16:15" "16:16" "16:17" "16:18" "16:19" "16:20"
#>  [982] "16:21" "16:22" "16:23" "16:24" "16:25" "16:26" "16:27" "16:28" "16:29"
#>  [991] "16:30" "16:31" "16:32" "16:33" "16:34" "16:35" "16:36" "16:37" "16:38"
#> [1000] "16:39" "16:40" "16:41" "16:42" "16:43" "16:44" "16:45" "16:46" "16:47"
#> [1009] "16:48" "16:49" "16:50" "16:51" "16:52" "16:53" "16:54" "16:55" "16:56"
#> [1018] "16:57" "16:58" "16:59" "17:00" "17:01" "17:02" "17:03" "17:04" "17:05"
#> [1027] "17:06" "17:07" "17:08" "17:09" "17:10" "17:11" "17:12" "17:13" "17:14"
#> [1036] "17:15" "17:16" "17:17" "17:18" "17:19" "17:20" "17:21" "17:22" "17:23"
#> [1045] "17:24" "17:25" "17:26" "17:27" "17:28" "17:29" "17:30" "17:31" "17:32"
#> [1054] "17:33" "17:34" "17:35" "17:36" "17:37" "17:38" "17:39" "17:40" "17:41"
#> [1063] "17:42" "17:43" "17:44" "17:45" "17:46" "17:47" "17:48" "17:49" "17:50"
#> [1072] "17:51" "17:52" "17:53" "17:54" "17:55" "17:56" "17:57" "17:58" "17:59"
#> [1081] "18:00" "18:01" "18:02" "18:03" "18:04" "18:05" "18:06" "18:07" "18:08"
#> [1090] "18:09" "18:10" "18:11" "18:12" "18:13" "18:14" "18:15" "18:16" "18:17"
#> [1099] "18:18" "18:19" "18:20" "18:21" "18:22" "18:23" "18:24" "18:25" "18:26"
#> [1108] "18:27" "18:28" "18:29" "18:30" "18:31" "18:32" "18:33" "18:34" "18:35"
#> [1117] "18:36" "18:37" "18:38" "18:39" "18:40" "18:41" "18:42" "18:43" "18:44"
#> [1126] "18:45" "18:46" "18:47" "18:48" "18:49" "18:50" "18:51" "18:52" "18:53"
#> [1135] "18:54" "18:55" "18:56" "18:57" "18:58" "18:59" "19:00" "19:01" "19:02"
#> [1144] "19:03" "19:04" "19:05" "19:06" "19:07" "19:08" "19:09" "19:10" "19:11"
#> [1153] "19:12" "19:13" "19:14" "19:15" "19:16" "19:17" "19:18" "19:19" "19:20"
#> [1162] "19:21" "19:22" "19:23" "19:24" "19:25" "19:26" "19:27" "19:28" "19:29"
#> [1171] "19:30" "19:31" "19:32" "19:33" "19:34" "19:35" "19:36" "19:37" "19:38"
#> [1180] "19:39" "19:40" "19:41" "19:42" "19:43" "19:44" "19:45" "19:46" "19:47"
#> [1189] "19:48" "19:49" "19:50" "19:51" "19:52" "19:53" "19:54" "19:55" "19:56"
#> [1198] "19:57" "19:58" "19:59" "20:00" "20:01" "20:02" "20:03" "20:04" "20:05"
#> [1207] "20:06" "20:07" "20:08" "20:09" "20:10" "20:11" "20:12" "20:13" "20:14"
#> [1216] "20:15" "20:16" "20:17" "20:18" "20:19" "20:20" "20:21" "20:22" "20:23"
#> [1225] "20:24" "20:25" "20:26" "20:27" "20:28" "20:29" "20:30" "20:31" "20:32"
#> [1234] "20:33" "20:34" "20:35" "20:36" "20:37" "20:38" "20:39" "20:40" "20:41"
#> [1243] "20:42" "20:43" "20:44" "20:45" "20:46" "20:47" "20:48" "20:49" "20:50"
#> [1252] "20:51" "20:52" "20:53" "20:54" "20:55" "20:56" "20:57" "20:58" "20:59"
#> [1261] "21:00" "21:01" "21:02" "21:03" "21:04" "21:05" "21:06" "21:07" "21:08"
#> [1270] "21:09" "21:10" "21:11" "21:12" "21:13" "21:14" "21:15" "21:16" "21:17"
#> [1279] "21:18" "21:19" "21:20" "21:21" "21:22" "21:23" "21:24" "21:25" "21:26"
#> [1288] "21:27" "21:28" "21:29" "21:30" "21:31" "21:32" "21:33" "21:34" "21:35"
#> [1297] "21:36" "21:37" "21:38" "21:39" "21:40" "21:41" "21:42" "21:43" "21:44"
#> [1306] "21:45" "21:46" "21:47" "21:48" "21:49" "21:50" "21:51" "21:52" "21:53"
#> [1315] "21:54" "21:55" "21:56" "21:57" "21:58" "21:59" "22:00" "22:01" "22:02"
#> [1324] "22:03" "22:04" "22:05" "22:06" "22:07" "22:08" "22:09" "22:10" "22:11"
#> [1333] "22:12" "22:13" "22:14" "22:15" "22:16" "22:17" "22:18" "22:19" "22:20"
#> [1342] "22:21" "22:22" "22:23" "22:24" "22:25" "22:26" "22:27" "22:28" "22:29"
#> [1351] "22:30" "22:31" "22:32" "22:33" "22:34" "22:35" "22:36" "22:37" "22:38"
#> [1360] "22:39" "22:40" "22:41" "22:42" "22:43" "22:44" "22:45" "22:46" "22:47"
#> [1369] "22:48" "22:49" "22:50" "22:51" "22:52" "22:53" "22:54" "22:55" "22:56"
#> [1378] "22:57" "22:58" "22:59" "23:00" "23:01" "23:02" "23:03" "23:04" "23:05"
#> [1387] "23:06" "23:07" "23:08" "23:09" "23:10" "23:11" "23:12" "23:13" "23:14"
#> [1396] "23:15" "23:16" "23:17" "23:18" "23:19" "23:20" "23:21" "23:22" "23:23"
#> [1405] "23:24" "23:25" "23:26" "23:27" "23:28" "23:29" "23:30" "23:31" "23:32"
#> [1414] "23:33" "23:34" "23:35" "23:36" "23:37" "23:38" "23:39" "23:40" "23:41"
#> [1423] "23:42" "23:43" "23:44" "23:45" "23:46" "23:47" "23:48" "23:49" "23:50"
#> [1432] "23:51" "23:52" "23:53" "23:54" "23:55" "23:56" "23:57" "23:58" "23:59"

^{Created on 2021-11-15 by the reprex package (v2.0.0)}

user_9462095 · Answer

Here's a base R solution:

sub("^0","", strftime(as.POSIXct("00:00", format="%H:%M")+seq(0,86380,by=60), format="%H:%M") )

user_8039978 · Answer

A regex solution with sub and backreference \1:

sub("^(\d)(?=:)", "0\1", hours_mins, perl = TRUE)
 [1] "00:00" "00:01" "05:09" "05:10" "05:11" "05:12" "05:14" "05:15" "23:58" "23:59"

Data:

hours_mins <- c("0:00",  "0:01","5:09",  "5:10",  "5:11",  "5:12",  "5:14",  "5:15","23:58", "23:59")

Truncated display of hour in R

3 Answers