Hi,
I'm new here. Is it possible to get Excel to add together time values (hours and/or minutes) and come up with a total time?
For example 1hr 03mins + 2 hrs 50 mins + 30 mins = 4 hrs 23 mins
Many thanks
Hi,
I'm new here. Is it possible to get Excel to add together time values (hours and/or minutes) and come up with a total time?
For example 1hr 03mins + 2 hrs 50 mins + 30 mins = 4 hrs 23 mins
Many thanks
can try like
=TIME(1,30,0)+TIME(,,30)+TIME(1,25,0)+TIME(0,30,0)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
or can try
=TIMEVALUE("1:30")+TIMEVALUE("0:30")+TIMEVALUE("0:10")+TIMEVALUE("0:05")
Many thanks for your help, nflsales.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks