LinkBack URL
About LinkBacks
I'm working on a time sheet.
I have hours worked in decimal eg 7.5
I also have negative -7.5
How do I convert this into 7:30 and -7:30??
Many thanks
Emyr
I'm working on a time sheet.
I have hours worked in decimal eg 7.5
I also have negative -7.5
How do I convert this into 7:30 and -7:30??
Many thanks
Emyr
You can use negative times if you switch to the 1904 date system
Custom format result cell as hour
=A1/24
Last edited by Ali Kırksekiz; 04-02-2015 at 10:26 AM.
Thanks
I've tried that and it works, some think that it may cause problem when sharing document with others?
Regards
Emyr
How about this?
=TRUNC(A1,0)&":"&TEXT((MOD(A1,1))*60,"00")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks