Thread
:
convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Leo Rod
external usenet poster
Posts: 21
convert hours format to decimal or minutes (exp. 1:15:00 = 75 min.
To convert it to a value:
=MINUTE(A1)+(HOUR(A1)*60)
where A1 is the time.
"hard working andy w" <hard working andy
wrote
in message ...
How do I copy and past a help example to a blank spreadsheet pertaining to
the above subject?
I can subtract an end time from a begin time to get hours and minutes
(1:15:00 or 75 minutes).
How do I convert 1:15:00 to 75 minutes?
Reply With Quote
Leo Rod
View Public Profile
Find all posts by Leo Rod