subtract half an hour from hours and minutes

M

MajorGeneralDes

could somebody please point me in the right direction here. Im tryin
subtract 30 minutes form a cell containing a number of hours an
minutes formatted using [h}:mm custom cell forma
 
J

Jason Morin

Any of these will work:

=A1-"00:30"
=A1-TIME(,30,)
=A1-1/24/2

HTH
Jason
Atlanta, GA
 
M

MajorGeneralDes

thanks jason. I did work it out but i did it the long way round compare
to your way.
cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting 37 hours from a cell containing format [h]:mm 2
Converting dd:hh:mm to [h]:mm not working. 3
Difference between dates and times 5
Summing Hours and Minutes 1
I need to find the yy/mm/dd AND hh:mm:ss between 2 time stamps 5
Diference between two hours in Minutes 3
How to convert an elapsed time in minutes to Days hours and minute 1
Hours and sum of hours 2

Top