Thread
:
how do i convert minutes to hours
View Single Post
#
2
Posted to microsoft.public.excel.misc
Niek Otten
external usenet poster
Posts: 3,440
how do i convert minutes to hours
Hi Miriam,
If the minutes are supplied as a number (of minutes):
=A1/24/60
Format as Time
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"m fournier" <m
wrote in message ...
|I have a spreadsheet that was forwarded to me in minutes but I need to covert
| these minutes to hours ie 74 minutes should be 1:14 minutes.
|
| Any suggestions?
|
| Miriam
|
Reply With Quote
Niek Otten
View Public Profile
Find all posts by Niek Otten