hh:mm:ss to days

  • Thread starter Thread starter Omar
  • Start date Start date
O

Omar

Dear all,
How can convert hh:mm:ss to days.
for example 76:22:00 to days.
Many thanks.
 
Hi Omar...

Though if it is real Excel time value 76:22:00 in A1
then in A2 type : =INT(A1)
cell format "general"

Regards
 
You must log in or register to reply here.

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

Getting MM-DD HH:MM out of Julian date 4
Sum of minutes and seconds times price? 2
How to convert serial date&time to normal date&time? 2
How can I Sum time duration? 1
Shortcut for current Time in hh:mm:ss 2
Access Access 2010 - Date()-1 and times in query 0
Time Format or Time conversion 4
Computing minutes, days and years 3

Back
Top