hms-example.org

Illustration

HMS	Seconds %.2f
0@ 00’ 01”	1.00
0@ 0’ 2.3”	2.00
0@ 0’ 2.5”	2.00
0@ 1’ 59.5”	119.00

Some more HMS calculations

Some multiplications by 2 show that the HMS form isn’t incapable of storing fractional seconds and operating on them; it just turns into integers whenever you use %f to display them.

HMS	Seconds	HMS x 2	Seconds x 2	HMS x 2
0@ 00’ 01”	1.00	0@ 0’ 2.”	2.00	2.00
0@ 0’ 2.3”	2.00	0@ 0’ 4.6”	4.00	4.00
0@ 0’ 2.5”	2.00	0@ 0’ 5.”	4.00	5.00
0@ 0’ 2.99”	2.00	0@ 0’ 5.98”	4.00	5.00
1@ 1’ 1”	3660.00	2@ 2’ 2.”	7320.00	7321.00
1@ 0’ 1.5”	3601.00	2@ 0’ 3.”	7202.00	7203.00
0@ 0’ 30”	30.00	0@ 1’ 0”	60.00	60.00
0@ 0’ 30.5”	30.00	0@ 1’ 1.”	60.00	61.00

From the “Formula syntax for Calc” Info page, I see no way other than %f to turn an HMS form into a plain number short of Elisp. For example:

HMS	%.2f	t	T	U	e4	p20
0@ 00’ 01”	1.00	0	00:00:00	00:00	0@ 0’ 1”	0@ 0’ 1”
0@ 0’ 2.3”	2.00	0	00:00:00	00:00	0@ 0’ 2.3e0”	0@ 0’ 2.3”
0@ 0’ 2.5”	2.00	0	00:00:00	00:00	0@ 0’ 2.5e0”	0@ 0’ 2.5”
0@ 0’ 2.99”	2.00	0	00:00:00	00:00	0@ 0’ 2.99e0”	0@ 0’ 2.99”
1@ 1’ 1”	3660.00	3600	01:00:00	01:00	1@ 1’ 1”	1@ 1’ 1”
1@ 0’ 1.5”	3601.00	3600	01:00:00	01:00	1@ 0’ 1.5e0”	1@ 0’ 1.5”
0@ 0’ 30”	30.00	0	00:00:00	00:00	0@ 0’ 30”	0@ 0’ 30”
0@ 0’ 30.5”	30.00	0	00:00:00	00:00	0@ 0’ 30.5e0”	0@ 0’ 30.5”